Financial Function Homework

.docx

School

Austin Community College District *

*We aren’t endorsed by this school

Course

2325

Subject

Finance

Date

May 1, 2024

Type

docx

Pages

1

Uploaded by BrigadierDinosaur4241 on coursehero.com

Financial Function Homework: Suzy is wanting to purchase a home and is trying to figure out how to arrange the financing for her purchase. This is her first time buying a house and so she is looking at all the financing options available to her. She has a budget she must stay within, so that is a major factor in how she will determine which option to choose. She has savings that she can apply to a down payment. She’s not sure if she wants to use all her savings on the down payment. Help her analyze her options by completing the Loan Analysis worksheet. Once a decision has been made about which option to choose, complete the Amortization table for her so she will know how her payments will be applied to interest and principal. Instructions: Loan Analysis worksheet: 1. Name the cells E3, E4, and J21 with an appropriate cell name that will convey the contents of the cell. 2. In cells E7:E13 calculate the loan amount borrowed. The amount borrowed will be the difference between the purchase price and the down payment applied to the loan. 3. In cells F7:F13 calculate the monthly payment amount under each option using the PMT function. Change the payment so it shows as a positive rather than a negative number. 4. Answer the analysis questions below the table using the financial functions learned. (Goal seek is not acceptable. You must use financial functions.) Amortization Table worksheet: 1. In B2, use a 3-D cell reference to link to the loan value for the option you selected in the loan analysis worksheet. . 2. In cells B3:B5, link to the appropriate cells from the Loan Analysis worksheet. 3. Name cells B2:B5 using the Create from selection option in the Defined Names section of the Formula ribbon. 4. Based on the option you selected on the Loan Analysis worksheet, starting in A8 of your amortization table, fill the number of payments you will need to make to bring your loan value to 0 by the end of your amortization table. Example 15 years and 4 payments per year would be 15*4=60 payments. Your payments would go from 1 to 60 down the page. 5. Link B8 to your beginning loan value. 6. Create your PPMT, IPMT and remaining balance. (hint: if you add the IPMT and PPMT values together it should equal the Periodic payment.) 7. Complete the amortization schedule. Your ending balance should be 0.
Discover more documents: Sign up today!
Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help