Question: please solve in Excel showing all the formulas A loan of 50,000 is taken out at 11% per year effective. Repay- ment is by the

please solve in Excel showing all the formulas

A loan of 50,000 is taken out at 11% per year effective. Repay- ment is by the amortization method, with equal payments at the end of each year for the next 20 years. Immediately after the 10th payment, the borrower renegotiates with the lender, and they agree that the remainder of the loan will be repaid by the sinking fund method, where the interest rate on the loan increases to 12% per year and the sinking fund earns interest at 14% per year. Interest payments and sinking fund deposits will still be annual and continue for 10 more years. Find the sinking fund deposit, and compare the borrower's new total payment with his old one

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Run an experiment to see whether you can replicate Mason Haires instant coffee experiment (see Branding Brief 10-2). Do the same attributions still hold? If not, can you replace coffee with a brand...

27. A loan of 50,000 is taken out at 11% per year effective. Repay- ment is by the amortization method, with equal payments at the end of each year for the next 20 years. Immediately after the 10th...

please solve in Excel with all the formulas Helen wishes to borrow 7 000 to buy a car. One lender offers a loan in which the principal is to be repaid at the end of 5 years. In the meantime, interest...

PowerPoint Assignment for BUS 401: Principles of Finance You have been asked by a manager in your organization to put together a training program explaining Net Present Value (NPV) and Future Value...

Can anyone solve the answers from the given document givenbelow? I really need help. MY FINAL LITERALLY IS KNOCKING AT THE DOOR. Name_________________________________ Student...

1. A bank is paying interest at a 5% annual rate on deposits. If you invest 10,000 and the bank compounds interest daily (i.e., 365 times per year), which of the following shows how much you will...

SOMEONE PLEASE HELP ME GIVE ALL THE ANSWERS!!!!! MY EXAM IS ON 13th MORNING! SO PLEASEEEEE!!!!! 2. An investment is expected to pay the following: C 1 = $2,300, C 2 = $2,600, C 3 = $2,900, and then...

Ch Overview In-depth discussion Amortization method of paying off debts. Amortization problem = ordinary simple annuity of equal PMTs & equal PMT periods PMTS made @ end of PMT period & PMT period &...

The Chocolate Shop - F23 Overview Susie is determined to start her own chocolate business. She has some experience in the industry and is now signed up for a "Professional Chocolatier Program"...

I need your help with this: Can you please quote from the attached chapters / resource if possible? Corporations often use different costs of capital for different operating divisions. Using an...

Seitz Glassware is trying to determine its growth rate for its an annual cash dividend. Last years dividend was $0.25 per share. The stocks target return rate is 10%. What is the stocks price if a....

Discuss the advantages and disadvantages of regulation (as you see it).

The contribution margin per unit A recent income statement of Drake Industries reported the following data: Sales Revenue|$7,500,000 Variable Costs $4,125,000 Fixed Costs $2,850,000 If these data are...

- 2. Consider this combustion reaction. C4H10(9) + 9/202(9) 4CO2(g) + 5H2O(1) AH = -2959.4 kJ/mol a. Write the full equation for AE when 16 g of CO2 are formed at 1 atm and 340. K. I used 44.01 for...

7. Give three reasons a budget deficit might be a good policy choice.

1. Forrest is starting a lawn care business but needs to buy lawnmowers. He gets some money from Jenny, whom Forrest will pay back over time with interest of 6 percent, and some money from Dan, whom...

2. Putting your retirement saving in a mutual fund is better than putting it all in Netflix stock because doing so eliminates a. adverse selection. b. moral hazard. c. systematic risk. d....