Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Make a spreadsheet that should be able to do various calculations using automated formulas. Fully amortizing, partially amortizing (balloon), partial interest only or Interest only
Make a spreadsheet that should be able to do various calculations using automated formulas.
- Fully amortizing, partially amortizing (balloon), partial interest only or Interest only (bullet).
- there should be no balance or payment of interest past the term or error messages
- Yield with or with out closing costs.
- Interest Only periods.
- should be fully formula driven
- Able to change loan amount, amortization period, term length, interest rate.
An important step in this is getting the payment right. I will give you two assists. the formula for the payment is =IF(current period>term,"",IF(current period<=interest only period, io payment,IF(current priod=term, balloon payment,cpm)))
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started