Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This question uses excel. Please provide any formulas and steps necessary to complete it. Thanks! You wish to borrow $275,000 for a home. The payments

This question uses excel. Please provide any formulas and steps necessary to complete it. Thanks!

image text in transcribed

You wish to borrow $275,000 for a home. The payments are monthly for 30 years and Your APR is 5%. Note that the loan is compounded monthly and you are not dealing with an annual rate of 5%. Please do the following: (a) Calculate the monthly payment using the PMT function in Excel rounded to the penny (not displayed that way but truly rounded). Create an amortization table for the full life of the loan. Please construct the payment to make either the scheduled payment or the appropriate payment to pay off the loan if the ending balance would have been within $10 of the scheduled payment. All 360 pavment cells should have this same formula. I found the ABS function to be helpful. (b) To the side of your amortization table, populate two columns to show the break- down of each payment into principal and interest components. (c) Please plot the amount of principal and interest paid each month. In addition, plot the loan balance. Your scale for the balance will dwarf your principal and interest payments, so use the right axis for your loan balance. Fix the range of that axis to be $0 to $300,000. The axis on the right is called a secondary axis in Excel. An example is shown below. Bicycle Sales 400 525 500 300 450 E 425 400 100 1999 2000 2001 2002 2003 Bicycles SoldAverage Price

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Financial Management

Authors: Brigham, Daves

10th Edition

978-1439051764, 1111783659, 9780324594690, 1439051763, 9781111783655, 324594690, 978-1111021573

More Books

Students also viewed these Finance questions