Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Textbook Question
thumb_up100%
Chapter 22, Problem 2R
Open the file MASTER from the website for this book at cengagebrain.com. Enter all the formulas where indicated on the worksheet. Check to be sure that your balance sheet balances. Enter your name in cell A1. Save the completed file as MASTER2. Print the worksheet when done. Also print your formulas using fit-to-1 page scaling. Check figures: Borrowing (cell B78), $7,280;
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
A borrower has two alternatives for a loan: (1) issue a $630,000, 75-day, 6% note or (2) issue a $630,000, 75-day note that the creditor discounts at 6%. Assume a 360-day
year. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below.
X
Open spreadsheet
a. Compute the amount of the interest expense for each option. Round your answer to the nearest dollar.
for each alternative.
b. Determine the proceeds received by the borrower in each situation. Round your answers to the nearest dollar.
< (1) $630,000, 75-day, 6% interest-bearing note: $
(2) $630,000, 75-day note discounted at 6%: $
c. Alternative
is more favorable to the borrower because the borrower
Find the interest earned on $5,750 deposited into a savings account for 3 1/2 years at an annual interest rate of 4 1/2%
a. What formula should be used?
b. What are you trying to find and what variable does it represent in the formula?
c. Solve the problem showing all of your work (must show all steps!!)
d. Interpet your answer using a complete sentence
You may use the box below to upoload a picture of your written explanation or type it out in the box. Use the "mountain"
button to add pictures.
With loans, spreadsheets make it easy to _____. (can be more than 1 of the options listed below)
a. Calculate the amortization schedule
b. Determine the number of remaining loan payments
c. Find the loan balance due at any time
d. Demonstrate the split between the principal and interest amounts.
Chapter 22 Solutions
Excel Applications for Accounting Principles
Ch. 22 - Ranger Industries has provided the following...Ch. 22 - Open the file MASTER from the website for this...Ch. 22 - Review the completed master budget and answer the...Ch. 22 - Suppose the company has to revise its estimates...Ch. 22 - Suppose the company has just the opposite news and...Ch. 22 - Prob. 6R
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- I posted this a few days ago. In the attached image is the updated trial balance. All I need is help with creating the balance sheet from the provided data. ACC 122 Fall 2020Comprehensive ProjectBestValue Corporation's Trial Balance at December 31, 20XX is presented below.All 20XX transactions have been recorded except for the items described on the next page.Debit CreditCash $ 109,890Accounts Receivable 28,789Inventory 25,540Debt Investments 0Land 55,674Buildings 215,850Equipment 75,120Allowance for Doubtful Accounts $ 1,027Accumulated Depreciation-Buildings 63,306Accumulated Depreciation-Equipment 16,048Accounts Payable 35,278Interest Payable 0Unearned Rent Revenue 48,900Dividends Payable 0Income Tax Payable 0Bonds Payable 0Discount on Bonds Payable 0Common Stock ($2 par) 29,200Paid in Capital in Excess of Par-Common Stock 44,580Preferred Stock ($60 par) 0Paid in Capital in Excess of Par-Preferred Stock 0Retained Earnings 107,904Treasury Stock 0Cash Dividends 0Sales Revenue…arrow_forward1) Use the Loan worksheet to complete the loan amortization table. In cell F2, insert the IPMT function to calculate the interest for the first payment. Copy the function to the range F3:F25. (The results will update after you complete the other functions and formulas.) 2) In cell G2, insert the PPMT function to calculate the principal paid for the first payment. Copy the function to the range G3:G25. 3) In cell H2, insert a formula to calculate the ending principal balance. Copy the formula to the range H3:H25. 4) Now you want to determine how much interest was paid during the first two years. In cell B10, insert the CUMIPMT function to calculate the cumulative interest after the first two years. Make sure the result is positive. 5) In cell B11, insert the CUMPRINC function to calculate the cumulative principal paid at the end of the first two years. Make sure the result is positive. 6) You want to perform a what-if analysis to determine the rate if the monthly payment is…arrow_forwardA borrower has two alternatives for a loan: (1) issue a $360,000, 75-day, 6% note or (2) issue a $360,000, 75-day note that the creditor discounts at 6%. Assume a 360-day year. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Calculate the amount of the interest expense for each option. Round your answer to the nearest dollar. $ ________________________ Determine the proceeds received by the borrower in each alternative. Round your answers to the nearest dollar. (1) $360,000, 75-day, 6% interest-bearing note: $___________________________ (2) $360,000, 75-day note discounted at 6%: $ _________________________arrow_forward
- Calculate the table factor, the finance charge, and the monthly payment (in $) for the loan by using the APR table, Table 13-1. (Round your answers to the nearest cent.) AmountFinanced Number ofPayments APR TableFactor FinanceCharge MonthlyPayment $7,900 36 10% $ $ $ https://www.webassign.net/brecmbc9/13-table-1.pdfarrow_forwardA borrower has two alternatives for a loan: (1) issue a $420,000, 30-day, 6% note or (2) issue a $420,000, 30-day note that the creditor discounts at 6%. Assume a 360-day year. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Calculate the amount of the interest expense for each option. Round your answer to the nearest dollar. $ fill in the blank 2 for each alternative. Determine the proceeds received by the borrower in each alternative. Round your answers to the nearest dollar. (1) $420,000, 30-day, 6% interest-bearing note: $ fill in the blank 3 (2) $420,000, 30-day note discounted at 6%: $ fill in the blank 4 Alternative 1 is more favorable to the borrower because the borrower receives more cash .arrow_forwardCalculate the table factor, the finance charge, and the monthly payment (in $) for the loan by using the APR table, Table 13-1. (Round your answers to the nearest cent.)arrow_forward
- Cy loans Mookie The Beagle™ Concierge $2,000 at 6% annual interest. Record the transaction as a loan payable as follows. Complete a Deposit. Select Create (+) icon > Bank Deposit Select Account: Checking Select Date: 01/12/2022 In Add Funds to This Deposit section, select Account: + Add New > Loan Payable > Account Type: Other Current Liabilities > Detail Type: Loan Payable > Name: Loan Payable, then select Save and close Select Payment Method: Check Enter Ref No.: 5002 Enter Amount: 2000.00 Select Save and close What is the Amount of the Loan Payable? (Answer this question in the table shown below. Round your answer 2 decimal places.) View the Transaction Journal for the Deposit. From the Navigation Bar, select Accounting From the Chart of Accounts, select Loan Payable > View Register From the Register, select the transaction just recorded > Edit From the bottom of the Loan Payable transaction, select More > Transaction Journal What are the…arrow_forwardYou have 3 accounts: Account A has a $100 balance and a $300 credit limit. Account B has a $100 balance and a $500 credit limit. Account C has a $600 balance and a $1000 credit limit. Considering the debt-to-credit ratio for each account, if you have extra money to pay towards an account, which order should you pay the extra towards to increase your credit score?arrow_forwardpractice. need to double check work. use table to find 1. Loan Amount 2. monthly payment on a 30 year loan (use pmt) 3. total interest paid over the life of 30 year loanarrow_forward
- For the following economic calculations, write the factors (multipliers) that should be used,in (i) using the parameter values, and in (ii) calculate the result by showing your computations. Write the results you find in the spaces left. (Use factors for your calculations.)EXAMPLE: If you deposit $ 100 to a bank account that earns 8% annual interest, how much money will you have in this account after five years?(i)(F/P, 8%, 5) (ii)146.93100 * (F/P, 8%, 5) = 100 * 1.4693 = 146.93 TLa. You plan to take a credit with $1500 installment size per year with an annual interest rate of 8% over six years from a bank. What is the amount of your current credit?(i) (ii)b. A bank is required to deposit money for four years with an interest rate 10%. The money deposited at the end of the first year is 6000 TL and the amount of money deposited in the next three years will be reduced by 500 TL every year. How much money will be in the bank at the end of the fourth year?(i) (ii)arrow_forwardHi,how to use the excel function (IRR and Effect) to determine which money lender offers a better rate: 1. Ah Long Finance: Loan amount: $20,000; instalment $600 per month x 36 months 2. Sharky Finance: Loan amount: $30,000; instalment $555 per month x 60 months 3. Ah Beng Finance: Loan amount: 40,000; instalment $ 760 per month x 59 months 4. Barracuda Finance: Loan amount: $50,000; instalment $925 per month x 60 monthsThanks.arrow_forwardFind the following. (Round your answers to the nearest cent.) FinanceCharge Number ofPayments Frequency Amount Number ofPayments Left $9.10 12 Monthly $15 5 (b) the amount needed to pay off the loanarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
How To Analyze an Income Statement; Author: Daniel Pronk;https://www.youtube.com/watch?v=uVHGgSXtQmE;License: Standard Youtube License