Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
EXCEL WORKSHEET. I need help with formulas for missing information. Input Area Summary Calculations Complex Cost $950,000.00 Loan Amount Down Payment $400,000.00 No. Periods #
EXCEL WORKSHEET. I need help with formulas for missing information.
Input Area | Summary Calculations | ||||
Complex Cost | $950,000.00 | Loan Amount | |||
Down Payment | $400,000.00 | No. Periods | |||
# of Pmts per Year | 12 | Monthly Rate | |||
Years | 30 | Monthly Payment | |||
APR | 5.325% | Total Interest Paid | |||
1st Payment Date | 1/20/2017 | ||||
Payment # | Payment Date | Beginning Balance | Interest Paid | Principal Payment | Ending Balance |
1 | 1/20/2017 | ||||
2 | 2/20/2017 | ||||
3 | 3/20/2017 | ||||
4 | 4/20/2017 | ||||
5 | 5/20/2017 | ||||
6 | 6/20/2017 | ||||
7 | 7/20/2017 | ||||
8 | 8/20/2017 | ||||
9 | 9/20/2017 | ||||
10 | 10/20/2017 | ||||
11 | 11/20/2017 | ||||
12 | 12/20/2017 | ||||
13 | 1/20/2018 | ||||
14 | 2/20/2018 | ||||
15 | 3/20/2018 | ||||
16 | 4/20/2018 | ||||
17 | 5/20/2018 | ||||
18 | 6/20/2018 | ||||
19 | 7/20/2018 | ||||
20 | 8/20/2018 | ||||
21 | 9/20/2018 | ||||
22 | 10/20/2018 | ||||
23 | 11/20/2018 | ||||
24 | 12/20/2018 | ||||
25 | 1/20/2019 | ||||
26 | 2/20/2019 | ||||
27 | 3/20/2019 | ||||
28 | 4/20/2019 | ||||
29 | 5/20/2019 | ||||
30 | 6/20/2019 | ||||
31 | 7/20/2019 | ||||
32 | 8/20/2019 | ||||
33 | 9/20/2019 | ||||
34 | 10/20/2019 | ||||
35 | 11/20/2019 | ||||
36 | 12/20/2019 | ||||
37 | 1/20/2020 | ||||
38 | 2/20/2020 | ||||
39 | 3/20/2020 | ||||
40 | 4/20/2020 | ||||
41 | 5/20/2020 | ||||
42 | 6/20/2020 | ||||
43 | 7/20/2020 | ||||
44 | 8/20/2020 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started