Purchase Solution

Home financing options

Not what you're looking for?

Ask Custom Question

For a home that is priced at $599,000.00
and a down payment of 20% $119,800.

- Research 2 different financing options. Use Excel (or other approved spread sheet) to create an amortization schedule for the life of both financing options.

- Write an analysis that compares and contrasts the two financing options in detail.

Purchase this Solution

Solution Summary

This solution includes a comparison of two different financing options and an amortization schedule for both options in Excel.

Solution Preview

** Please see the attached Excel file for the amortization schedule **

I have attached a spreadsheet that has an amortization schedule for a 30 year fixed rate loan with no points and a 30 year fixed rate loan with points paid. I have made the Excel sheet more complex than required; but I put zeros in those spots in less you want to use them (you could include tax, lower the down payment so that PMI is included, or calculate the tax on the house).

This analysis will compare and contrast two different financing options. The options that were considered for this analysis are a traditional 30 year fixed rate mortgage with no points paid ...

Purchase this Solution


Free BrainMass Quizzes
Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

Lean your Process

This quiz will help you understand the basic concepts of Lean.