using excel with formulas

A. Yoa are thinking of parchaving a bosse that coses 5463,000. You have $25,060 in cash that you can uise as a down payment, but you mecd bo borrow the rest of the purchase price. Assume there are mo clooing costs. The back is offerieg a 20 -year morteage that requires moenthy payments and has an anmal interest rate of 5:35% per year. - What will your mocithly payments be if you siga ep for thais mectgage? - Prekent the amortization schedule (Begiecing balance, Mowiby pament, Princinol perment. Inierent papwent, Ending bataece) en a moethly basis asing Exeel. - Calealate the total amount of interest paid throughout the lifo of the loan foum up the amounts in the lntercet column) - Create a wraph depicting the monthly paymetts and the portions of interes and principul for cach monthly paymeet throeghest the life of the lean. 3. Suppore you have the epcoon to take oti a 15-year morigage with us annual interest rate of 5.I3P. What wid the few moesthly paymint be? - Present a pew anortiratice schedule (Eegieving bulance, Mondhly payment. Princripal pajmexe, initered priment, Einalieg balance) on a new werksoet in the same Fecel woekboek. - Calculate the total amount of interest paid theoeghout the life of the loan (sum ap the artounts in the Interevt calumin). - Crcate a graph depicting the monthly payments and the poetions of intereat asd princigal for each menthly payment thtoughout tie lifo of the loan. E. How much do you save if you go with the 15 -ycar isoeteage versas the 20 -year mortgage esample above? Refercose the pperopriate oells in the peeviges workshets to compute the difference on thes woekiceet. Please chaborate on tho savings arsoant in pords rather than simply providing the differcace figure. (Hart, Compute the differebce betwoen the sotal interest paid in parts A and B ). A. Yoa are thinking of parchaving a bosse that coses 5463,000. You have $25,060 in cash that you can uise as a down payment, but you mecd bo borrow the rest of the purchase price. Assume there are mo clooing costs. The back is offerieg a 20 -year morteage that requires moenthy payments and has an anmal interest rate of 5:35% per year. - What will your mocithly payments be if you siga ep for thais mectgage? - Prekent the amortization schedule (Begiecing balance, Mowiby pament, Princinol perment. Inierent papwent, Ending bataece) en a moethly basis asing Exeel. - Calealate the total amount of interest paid throughout the lifo of the loan foum up the amounts in the lntercet column) - Create a wraph depicting the monthly paymetts and the portions of interes and principul for cach monthly paymeet throeghest the life of the lean. 3. Suppore you have the epcoon to take oti a 15-year morigage with us annual interest rate of 5.I3P. What wid the few moesthly paymint be? - Present a pew anortiratice schedule (Eegieving bulance, Mondhly payment. Princripal pajmexe, initered priment, Einalieg balance) on a new werksoet in the same Fecel woekboek. - Calculate the total amount of interest paid theoeghout the life of the loan (sum ap the artounts in the Interevt calumin). - Crcate a graph depicting the monthly payments and the poetions of intereat asd princigal for each menthly payment thtoughout tie lifo of the loan. E. How much do you save if you go with the 15 -ycar isoeteage versas the 20 -year mortgage esample above? Refercose the pperopriate oells in the peeviges workshets to compute the difference on thes woekiceet. Please chaborate on tho savings arsoant in pords rather than simply providing the differcace figure. (Hart, Compute the differebce betwoen the sotal interest paid in parts A and B )