Loan Amortization Scenario
Since everyone is in a different financial situation, choose the scenario that interests you the most. Of course, you do not have to share your personal financial position; you are welcome to invent the starting figures.
Solve with Excel Please!
Buying a Home What is your monthly net income? How much "house" can you afford? The rule of thumb is that you can buy housing that runs about two-and-one-half times your annual salary. (Lesson 8) Step 1 Go to www.har.com, www.zillow.com, or other area real estate website and, based on your estimate of affordability, search for a home in an area that you desire that you can afford. Take a screenshot of that page and insert the image in your spreadsheet. Step 2 Calculate the customary 20% down payment. Do you have the money for a 20% down payment or must you make an adjustment? Step 3 Research loan offers and find the best mortgage rate for the down payment you can afford. Take a screenshot of that page and insert the image in your spreadsheet. Calculate the monthly mortgage payment and compare it to your monthly net income. If the monthly mortgage payment is too much of your monthly net income, you may want to search for a different home. Step 4 Using all of the information that you have researched, complete an amortization table for your loan at the best mortgage rate you found, with your 20% down payment. Step 5 - The spreadsheet with its calculations and answers to all of the questions. Submi Buying a New/Used Car What is your monthly net Income? Consider the type of car you wish to own and why that type of car would be best for your needs. (Lesson 17) Step 1 How much "car" can you afford? The rule of thumb is to plan on spending 10% to 15% of your total monthly budget on all automotive expenses. This includes gas, insurance, regular maintenance. Calculate the amount that you can afford. Step 2 Go to www. Edmunds.com , www. Cars.com, or other website or classified ad and, based on your estimate of affordability, search for a car in an area that you desire that you can afford. Take a screenshot of that page and insert the image in your spreadsheet. Step 3 Calculate the customary 20% down payment. Do you have the money for a 20% down payment or must you make an adjustment? Research loan offers and find the best car loan rate. Take a screenshot of that page and insert the image in your spreadsheet. Step 4 Using all of the information that you have researched, complete an amortization table for your loan at the best interest loan rate you found. Step 5 The spreadsheet with us calculations and answers to all of the questions. Submit Buying a Home What is your monthly net income? How much "house" can you afford? The rule of thumb is that you can buy housing that runs about two-and-one-half times your annual salary. (Lesson 8) Step 1 Go to www.har.com, www.zillow.com, or other area real estate website and, based on your estimate of affordability, search for a home in an area that you desire that you can afford. Take a screenshot of that page and insert the image in your spreadsheet. Step 2 Calculate the customary 20% down payment. Do you have the money for a 20% down payment or must you make an adjustment? Step 3 Research loan offers and find the best mortgage rate for the down payment you can afford. Take a screenshot of that page and insert the image in your spreadsheet. Calculate the monthly mortgage payment and compare it to your monthly net income. If the monthly mortgage payment is too much of your monthly net income, you may want to search for a different home. Step 4 Using all of the information that you have researched, complete an amortization table for your loan at the best mortgage rate you found, with your 20% down payment. Step 5 - The spreadsheet with its calculations and answers to all of the questions. Submi Buying a New/Used Car What is your monthly net Income? Consider the type of car you wish to own and why that type of car would be best for your needs. (Lesson 17) Step 1 How much "car" can you afford? The rule of thumb is to plan on spending 10% to 15% of your total monthly budget on all automotive expenses. This includes gas, insurance, regular maintenance. Calculate the amount that you can afford. Step 2 Go to www. Edmunds.com , www. Cars.com, or other website or classified ad and, based on your estimate of affordability, search for a car in an area that you desire that you can afford. Take a screenshot of that page and insert the image in your spreadsheet. Step 3 Calculate the customary 20% down payment. Do you have the money for a 20% down payment or must you make an adjustment? Research loan offers and find the best car loan rate. Take a screenshot of that page and insert the image in your spreadsheet. Step 4 Using all of the information that you have researched, complete an amortization table for your loan at the best interest loan rate you found. Step 5 The spreadsheet with us calculations and answers to all of the questions. Submit
