As gyms are getting crowded by the day, you decidedto invest in your own home-garage gym to squeeze inyour daily pump. For this purpose, you decided to gofor a 10,000$ bank loan at an interest rate of 10% for a3 years duration.The bank suggested 3 main payment alternatives thatyou can choose from:Alternative A: Paying the whole amount at the end.Alternative B: Paying the interest at an annual basiswhile the total principal is paid at the end.Alternative C: Paying interest + a portion of principalannually.In an excel spreadsheet, create a detailed payment planfor each of the 3 alternatives following the templatebelow.Year Owed interest Total owed interest End of year payment Total owed after payment0123

The question is based on the concept of fianancial management.

Answered: As gyms are getting crowded by the day,…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

You ran a little short on your spring break vacation, so you put $1,000 on your other credit card. You can afford only the minimum payment of $60 per quarter. The interest rate on the credit card is 18 per year compounded quarterly. How many years will you need to pay off the $1,000? I want to solve this problem using the financial calculator so if your able to show me what to punch in that would be great
You are going to purchase a new pick-up truck and decided to take a conventional vehicle loan in the amount of $60,175. You plan to finance the entire amount from a local bank. You plan to obtain a loan for 6 years and you were told the interest rate is 4.5% per year. Determine the monthly payments that you would make for the loan.
If you could solve option 5 with the formulas please Option 5: Half the required money is taken out of an investment account that pays monthly interest at a 3% annual rate. The rest of the money is borrowed from a bank at a 4% annual interest rate, should payback within 3 years in equal monthly payments. Find the future value of the money taken from the investment account at the end of the shop development and periodic payments to the bank. Calculate Cumulative interest and principal payments.
Please show me how to solve this in excel using an excel spreadsheet and please show the excel formulas! Thank You! A house price of $100,000 can be financed with two loans below with monthly payments. The total origination cost associated with these two loans in the table attached is $3000. Alternatively, the borrower can borrow one loan in the amount of $90,000 with monthly payments and origination cost of $2,000. What should the interest rate be on the loan of $90,000 so that the borrower will be indifferent between these two choices?
Your firm has an average receipt size of $90. A bank has approached you concerning a lockbox service that will decrease your total collection time by 2 days. You typically receive 9,100 checks per day. The daily interest rate is 0.019 percent. If the bank charges a fee of $200 per day, what is the NPV of the lockbox project? NPV What would the net annual savings be if the service were adopted? Net annual savings
You want to buy a $150,000 home. You plan to pay 5% as a down payment, and take out a 30 year loan at 4.9% interest for the rest. The bank will charge 3 points on the amount financed. a) What is the amount of the down payment? b) How much is the loan amount going to be? c) What will be the amount charged for 3 points? *1 point is 1 % of the mortgage amount d) Find the amount of the monthly payment. (Do not add the cost of the points to the loan amount) Hint: click here Question Help: D Video Message instructor %24
The local electronics store is offering a promotion "1-year: same as cash," meaning that you can buy a TV now, and wait a year to pay (with no interest). So, if you take home a $1,200 TV today, you will owe them $1,200 in one year. If your bank is offering 4% interest, what is the true cost of the TV to you today? The true cost of the TV to you today is $ (Round to the nearest cent.)
Quantitative Problem: You need $14,000 to purchase a used car. Your wealthy uncle is willing to lend you the money as an amortized loan. He would like you to make annual payments for 4 years, with the first payment to be made one year from today. He requires a 9% annual return. a. What will be your annual loan payments? Do not round intermediate calculations. Round your answer to the nearest cent. b. How much of your first payment will be applied to interest and to principal repayment? Do not round intermediate calculations. Round your answers to the nearest cent. Interest: $ Principal repayment: $
The amount the bank is willing to loan you to start your business is not enough to cover the initial investment you need to make. You need an additional $10,000. You approach an investor and ask him to invest $10,000 in your business. In return, you offer to pay him $500 out of your profits at the end of years 1-4 and an amount X at the end of year 5. The investor's annual cost of funds is 10%. How big must X be to induce him to invest in your business?
You want to buy a car, and the local bank will lend you $20,000. The loan will be fully amortized over 5 years (60 months) and the nominal interest rate will be 12%. The interest will be paid monthly. What will be the monthly loan payment? draw a time line and identify the known variables and unknown variables as if you were to input in EXCEL.
You want to borrow $300000 to start a business. The loan initial balance is increased by 2% of the loans face value(for loan originations fees, mortgage insurance,credit check,title searches etc) Your annual payments are calculated using an initial balance of $306000, an interest rate of 9% and a 20 year term. The bank requires you to refinance the loan in 5 years by paying it off with a balloon payment. what interest rate are you paying?

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS