Question: Please solve via excel and show calculation steps to solve table. Scenario: You have decided to finance a new home. The loan is for $248,000

Please solve via excel and show calculation steps to solve table.

Scenario: You have decided to finance a new home. The loan is for $248,000 and you are getting a rate of 5.9% per year compounded monthly. You have decided on a 15-year mortgage and will make monthly payments (end of the month). You decided you will pay 5% down at the beginning. You are working extra hours and expect to pay an extra $350 per month to knock down the principle. You make these payments for 6 years starting on month 25. The last EXTRA payment is on month 96.

Build the amortization table.

What month will you make your last payment?

How much will your last payment be?

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!

The case discusses the dilemma of the CFO of PSUWC Energy LLC, an energy generating firm, who needs to present his recommendation to the company Board regarding a proposed investment in a new...

I got this big assignmnet for Quantitative methods for business i really need help Azimi, Hamida - azihy004 AH Share Comments Delete this page before submission Q-Constructions - building your future...

I have attached the case study and the rubric for this. can I get help here to organzie an answer? CATERPILLAR, INC: THE IMPACT OF DECISION BIASES AND RISK ON CAPITAL BUDGETING Timothy D. West...

Case Analysis 1. Compute the yield to maturity of Land'o'Toys' bonds before the purchase announcement and use it to determine the likely current bond rating. (Compare YTM to the table on p. 269)....

Please create an excel spreadsheet with formulas for requirement 5 (pages 24-27)and requirement 6 (pages 28-31)only. Please submit in excel format. Both questions and answers are provided for...

can someone help me solve this? the data and informatiin is there for JP Morgan Chase with all the instructions. I sent the images in parts. it should be more clear now. unless you want me to email...

Executive Memorandum (EM) Guidelines Prepare an executive summary of the papers that is only one page long.The assignment should be typed in Word, font size 11 double spaced, with minimum margins of...

19 Name: ____________________________________ 1. Your friend has a credit card with an APR of 49.9% ! What would his finance charge be on a $500 charge for just 1 month? 2. Your friend has 2 credit...

Hello, Please, I really need help with this assignment. I submitted the assignment already, and I got feedbacks to solve the mistakes in my first submissions. I will attach the submissions ( The...

I'm looking for a full case solution on the case: Pelarsen Windows Humans vs. Robots. I've attached the full case. Please let me know, as i'd highly appreciate your help here. ISSN 1940-204X Pelarsen...

Prepare general journal entries (no explanations required) to record the following transactions for The Chocolate Factory in its first year of operations. Management intends to actively trade this...

What should be prepared every time a petty cash payment is made?

Which of the following is not a reason for the increased volume in the foreign trading of U . S . securities ? a . Primary dealers of U . S . Treasury notes and bonds have opened offices in various...

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...