Draw Cash Flow Diagrams

Can you help me with question 4 please

3. A family borrows $185.000 over 10 years at 4.75% annually compounded monthly. Compute their monthly payement and develop an amortization table that shows the split between interest and principal for each payement. Use Excels's IPMT and PPMT functions. Hand in a graph of the interst and principal component of each payement versus time with your short-hand calculations. 4. A family takes a $275,000 20 year mortage at 3.50% annually compounded monthly. a. Compute their monthly payments. b. Immediately after the 121st payment, this family receives a $55.000 from an inheritance. They decide to put this entire amount against the amount they owe. Given that the bank expects them to maintain the same monthly payments as in 4a, compute the length of time (months) it will take to pay the laon off