Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please show Excel Formulas used 2. (15 points) Using excel file to create the amortization schedule for a mortgage of $450,000.00 with a rate of

image text in transcribed

Please show Excel Formulas used

2. (15 points) Using excel file to create the amortization schedule for a mortgage of $450,000.00 with a rate of 1.85% (APR) for 15 years. Your excel file must contain the following information. Payment Schedule Payment Date Interest Due No. Interest Rate Principal Paid Year Payment Due 1 2 3 4 5 6 2021-11-01 2021-12-01 2022-01-01 2022-02-01 2022-03-01 2022-04-01 2022-05-01 2022-06-01 2022-07-01 2022-08-01 2022-09-01 2022-10-01 1.850% 1.850% 1.850% 1.850% 1.850% 1.850% 1.850% 1.850% 1.850% 1.850% 1.850% 1.850% 693.82 690.48 687.13 683.77 680.40 677.04 673.66 670.28 666.90 663.51 660.12 656.72 2,864.85 2,864.85 2,864.85 2,864.85 2,864.85 2,864.85 2,864.85 2,864.85 2,864.85 2,864.85 2,864.85 2,864.85 2,171.03 2,174.37 2,177.72 2,181.08 2,184.45 2,187.81 2,191.19 2,194.57 2,197.95 2,201.34 2,204.73 2,208.13 Balance $450,000.00 447,828.97 445,654.60 443,476.88 441,295.80 439,111.35 436,923.54 434,732.35 432,537.78 430,339.83 428,138.49 425,933.76 423,725.63 7 8 9 10 11 12 1 2. (15 points) Using excel file to create the amortization schedule for a mortgage of $450,000.00 with a rate of 1.85% (APR) for 15 years. Your excel file must contain the following information. Payment Schedule Payment Date Interest Due No. Interest Rate Principal Paid Year Payment Due 1 2 3 4 5 6 2021-11-01 2021-12-01 2022-01-01 2022-02-01 2022-03-01 2022-04-01 2022-05-01 2022-06-01 2022-07-01 2022-08-01 2022-09-01 2022-10-01 1.850% 1.850% 1.850% 1.850% 1.850% 1.850% 1.850% 1.850% 1.850% 1.850% 1.850% 1.850% 693.82 690.48 687.13 683.77 680.40 677.04 673.66 670.28 666.90 663.51 660.12 656.72 2,864.85 2,864.85 2,864.85 2,864.85 2,864.85 2,864.85 2,864.85 2,864.85 2,864.85 2,864.85 2,864.85 2,864.85 2,171.03 2,174.37 2,177.72 2,181.08 2,184.45 2,187.81 2,191.19 2,194.57 2,197.95 2,201.34 2,204.73 2,208.13 Balance $450,000.00 447,828.97 445,654.60 443,476.88 441,295.80 439,111.35 436,923.54 434,732.35 432,537.78 430,339.83 428,138.49 425,933.76 423,725.63 7 8 9 10 11 12 1

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_2

Step: 3

blur-text-image_3

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

Global Corporate Finance A Focused Approach

Authors: Kenneth Kim, Suk Kim

3rd Edition

9811207119, 9789811207112

More Books

Students also viewed these Finance questions

Question

119. If X is uniformly distributed on [1, 1], find the pdf of Y X2.

Answered: 1 week ago