How will increases in the cost of living effect the buyer

Assignment Help Financial Management
Reference no: EM132013592

Project: (due at the end of Unit 6)

Part I: Select a piece of real estate (residential, commercial, warehouse, land), any number of resources can be used (www.realtor.com is one option). You will need to include a listing sheet/link with your submitted assignment.

Part II: Determine a down payment. (a standard down payment is 20%, however you may offer justification for any amount/percent you choose)

Part III: Research 2 different financing options

Part IV: Use Excel (or other approved spread sheet) to create a complete amortization schedule for the lif of both financing options.

Part V: Write an analysis that compares and contrasts the two financing options in detail. Be specific. Include justifications for selecting an option.

Here is some more information regarding the project assigned in Unit 6. The project was designed to allow you to learn a bit about how the mortgage system works. I would suggest preparing the analysis from the perspective of the institution loaning the money. In this way you will need to design the financing options with the highest probability of getting your money back.

First of all, you should read the instructions on the Unit page carefully. Also, read the Rubric so you know how I will grade the projects. In addition to what is written, here are some further explanations for the five parts listed in the project.

Part 1: After you choose a property, determine all the extra monthly payments the buyer will have associated with the particular property. These are items like taxes, insurance, property fees, access fees, etc... You will need to take these into consideration when designing the financing options.

Part 2: Down payments are meant to protect the lender. It should be enough so it covers any costs and losses if there is a foreclosure early on in the term. But it shouldn't be too high so the buyer can't afford it. You need to think this through and you must justify any selection you make.

Part 3: There are many financing options available: fixed rate, variable rate, loans with points, balloon loans, just to name a few. The Wikipedia page has a nice description. I would like you to choose two different options and not just two variations of the same type. You should provide a detailed description of the options chosen. For example, you could choose a 30 year fixed mortgage and a 15 year ARM. This part is worth 10 points so make sure you have two different mortgages.

Part 4: Here you lay out the details of the two financing options you selected. Aside from presenting the details of the loans, provide information about the impact of the two options on the buyer. For example, what are the short and long term difference?

How will increases in the cost of living effect the buyer? What will happen if the interest rate suddenly increases? Don't forget, you want your money back plus the interest so think through what crazy things could happen in 15, 20, or 30 years. You must create the spreadsheet yourself. Simply including a spreadsheet you copied off the Internet will not suffice.

This part is worth 15 points so please do the work yourself. The equations that you enter in the cells of the spreadsheet can only utilize basic arithmetic and exponent operations. This way you are going to utilize what you learned in class. The way to compute an exponent in Excel is to use the power function. Excel has some very nice financial functions like IPMT and PMT which I suggest you use to check your equations but the spreadsheet you submit should NOT contain any of these.

Part 5: Here you will write an analysis of the two mortgage options. You should discuss in detail how each option will impact the buyer in the short and long term. I would like to see at least a half page of analysis. This part is worth 15 points and I will grade based on the effort you put into it.

I am expecting a Word document that has all five parts written out and an Excel spreadsheet that has the calculations for your two different mortgage options. As with all your college reports, the Word document should be APA formatted. If you are not familiar with the APA formatting guidelines you should spend some time on the Post Writing Center learning about it.

The project is worth a considerable portion of your final grade so please invest the time to do a thorough job. Good luck and please ask questions if something is unclear.

Reference no: EM132013592

Questions Cloud

Analyze the behavior of policyholders : Some supermarkets use loyalty programs which enable them to collect data about the shopping patterns of their customers. Suppose that an insurance company.
How can database impact on the workplace : How can Database impact on the workplace? What are database benefits when businesses use query?
What does it mean to you to be ethical : What does it mean to you to be ethical and what resources and tools will you utilize to help you when you face ethical challenges?
Descriptive research is conducted : What are the major purposes for which descriptive research is conducted?
How will increases in the cost of living effect the buyer : Write an analysis that compares and contrasts the two financing options in detail. Be specific. Include justifications for selecting an option.
Union optimism in the white collar area : Although white collar workers possess certain unique general properties that may tend to work against unionization in any event, present as strong
What skills improved the most : After you complete Assignment 4 and the self review, compare your evaluation to the one for Assignment 1. What skills improved the most?
What is the npv of project : If the expected return on the S&P500 Index is 7.0% and the risk-free rate is 1.0%, what is the NPV of this project (in millions)?
Evaluating employee behavior and work performance : The assessment of individual employee performance also needs to focus on evaluating employee behavior and work performance

Reviews

Write a Review

 

Financial Management Questions & Answers

  Foreign company acquisition

Acquisition by a foreign company and the effects of that decision and the results of foreign exchange in Euro and the exchange rate differences.

  Financial management for profit and non profit organizations

In this essay, we are going to discuss the issues of financial management in a non-profit organisation.

  Method for estimating a venture''s value

Evaluate venture's present value, cash and surplus cash and basic venture capital.

  Replacement analysis

This document show the Replacement Analysis of modling machine. Is replacement give profit to company or not?

  Business finance task - capital budgeting

Your company is considering using the payback period for capital-budgeting. Discuss the advantages and disadvantages of this technique.

  Analysis of the investment

In this project, you will focus on one of these: the additional cost resulting from the purchase of an apple press (a piece of equipment required to manufacture apple juice).

  Conduct a what-if analysis

Review the readings and media for this unit, including the Anthony's Orchard case study media. Familiarise yourself with the Anthony's Orchard company and its current situation.

  Determine operational expenditures

Organisations' behaviour is guided by financial data. In the short term, such data will help determine operational expenditures; in the long term, historical data may help generate forecasts aimed at determining strategic plans. In both instances.

  Personal financial management

How much will you have left over each half year if you adopt the latter course of action?

  Sources of finance for expansion into new foreign markets

A quoted company is considering several long-term sources of finance for expansion into new foreign markets.

  Long term financial planning

This assignment is designed for analyze Long term financial planning begins with the sales forecast and the key input in the long term fincial planning.

  Explain the role of fincial manager

This assignment explain the role of fincial manager, function of manger. And what are the motives of financial manager.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd