Which loan would you select and why

Assignment Help Financial Management

Reference no: EM131983762

a.-Build a mortgage payment schedule with the following assumptions. Assume that you are obtaining a $150k loan, 15 yr fixed interest rate is 3.194%, 30 yr fixed interest rate is 3.788%. Compare the two loans in terms of overall interest paid and define what the principle balance is after 12 years for each type of loan: the 15 yr and the 30 yr. Do not hard code the input variables into the spreadsheet.

b. Use Excel to Graph the Total Interest Paid and the Principle Remaining (on same graph) as a function of time (the independent variable) for both loans.

c. Which loan would you select and why?

Reference no: EM131983762

Questions Cloud

Presenting your project to fellow students : Develop a PowerPoint Presentation (six to eight slides) of your improvement project / research paper as though you were "presenting your project to your fellow

Why nick married honey which was were for her family money : Why Nick married Honey which was were for her family's money, it shows how society is money driven and how some men/women would do.

National venture capital association : Briefly review the membership list of the National Venture Capital Association and the focus of the venture funding association.

How cloud computing and open source software : Referring to the article Thrifty Does It discuss how cloud computing and open source software changes the landscape for tech start ups.

Which loan would you select and why : Use Excel to Graph the Total Interest Paid and the Principle Remaining (on same graph) as a function of time (the independent variable) for both loans.

Examples of ethical components of communication : What are some examples of ethical components of communication? Possible examples of positive ethical efforts that have been getting attention in the news?

Analyze the ipo by investigating the stocks issue price : Analyze the IPO by investigating the stock's issue price, number of shares, and increase in equity for the company.

Create project management plan that everybody : What actions are necessary to create Project Management Plan that everybody can approve?

Compute the portfolio beta : Select a portfolio of common stocks in five companies whose stock is traded on the New York Stock Exchange (NYSE).

User Account

All Pages