Verified Document

Using Future Cash Flows In A Financial Analysis Business Proposal

¶ … investment in a rental/real estate property. There is a one-time purchase of $10,000 in land that can subsequently be rented for a yearly $3,500 rent for a period of several years. At the end of the rental period, the investor aims to sell the land for a certain price. The longer the period of the rental is, in number of years, the more the land will degrade and, as a consequence, will be valued at a lower sum at the end of the entire period of time. As a consequence, the several scenarios that will be taken into consideration will look at a comparison between longer years of rental vs. lower price for the final sale of the land or a shorter period for the rental period, but a higher price for the final sale at the end of the rental period.

This paper will look at three different scenarios that will be analyzed according to criteria such as the net present value (looking at present worth and future worth and discounting future worth in order to obtain present worth), the internal rate of return (IRR) and other methods that include the cost effectiveness and benefit-cost instruments. The conclusion should be able to summarize as to which of the three scenarios is the optimal for the investor.

Another important element that needs to be defined is the discount rate that will be used in all the different calculations. The discount rate will be equivalent to the cost of capital, namely how much it would cost to receive a loan in order to pay for the investment in the rental property. The assumption for the rest of this paper is that this discount rate/cost of capital will be equal to 12%, which, in the Excel sheets, will be shown as 0.12.

For the first part of the paper, the hypothesis will be described for each of the three scenarios.

Scenario A

The investment in the rental property is worth $10,000. This will be shown in the financial analysis as Year 0. Each of the first three years of the renting the property produces an even $3,500 per year (Year 1, Year 2 and Year 3). The property will be sold in the 4th year for $3,500. This will be the result of the property gradually depreciating through time and losing its value...

This will be shown in the financial analysis as Year 0. Each of the first three years of the renting the property produces an even $3,500 per year (Year 1, Year 2 and Year 3). The property will be rented for another 2 years for $3,500. However, this will result in the property been more damaged at the end of the rental period, which will mean that it can only be sold for $$1,500 in the last year (Year 6), which will be the recorded cash flow for the respective year.
Scenario C

The investment in the rental property is worth $10,000. This will be shown in the financial analysis as Year 0. In this scenario, the property will only be rented out for three years and will be sold in Year 3 for a larger sum, the result of the property being less deteriorated over the rental period. The property will be sold in Year 3 for $4,500, which will be the cash flow for Year 3.

To resume, here are the following three scenarios that will be analyzed using the method previously mentioned in the introduction

Scenario A

Year

Cash Flows

0

($10,000)

1

$3,500

2

$3,500

3

$3,500

4

$3,500

Scenario B

Year

Cash Flows

0

($10,000)

1

$3,500

2

$3,500

3

$3,500

4

$3,500

5

$3,500

6

$1,500

Scenario C

Year

Cash Flows

0

($10,000)

1

$3,500

2

$3,500

3

$4,500

Financial Analysis (for all these analyses, the calculations are undertaken in the Excel spreadsheet. For each of the scenarios, a separate sheet was created, with the different values and the calculations for NPV, IRR etc.)

1. Net present value. The…

Sources used in this document:
Bibliography

1. Halpern, Paul et. Al, (1998). Managerial Finance. Dryden 2. Project Economics and Decision Analysis, Volume I: Deterministic Models, M.A.Main

3. Hazen, G.B., (2003). A new perspective on multiple internal rates of return. The Engineering Economist 48(2),
Cite this Document:
Copy Bibliography Citation

Related Documents

Financial Analysis Ucsd Is a Health Care
Words: 2516 Length: 7 Document Type: Essay

Financial Analysis UCSD is a health care provider that is considering the purchase of an MRI machine. An MRI is a tube that is surrounded by a giant circular magnet. It is used to scan patients, and has the benefit of being very safe relatively to radiation scanning. The purchase must be aligned, however, with the UCSD goal of providing high quality patient care and alleviating suffering. A significant number of

Cash Flow and Analysis
Words: 746 Length: 2 Document Type: Research Paper

Valuation Methods When it comes to the valuation of equities, there are three different methods that are commonly used. These three methods are the dividends valuation method, the free cash-flow method and the market-based method. As one might expect, there are pros and cons to each approach. As such, a proper compare and contrast of what is better in what ways and what is potentially inferior in other ways can and

Financial Analysis of Chevron From the Perspective
Words: 4187 Length: 10 Document Type: Essay

financial analysis of Chevron from the perspective of a potential creditor. The issue surrounds primarily the creditworthiness of Chevron rather than the type of credit that would be issued. Specifically, the issue is whether "we" would lend Chevron 10% of its net assets. The net assets for Chevron are $209.474 billion, so the amount in question is $20.9 billion in new debt. The report will first analyze the financial

Financial Analysis of Amazon.Com, Inc. 2012 Annual Report
Words: 3982 Length: 15 Document Type: Term Paper

AMZN Company Overview Amazon is a Fortune 100 company, recording over $61 billion in revenue in the 2012 fiscal year, with a net loss of $39 in that period. The company is a retailer, operating almost exclusively online. Amazon runs a large family of retail websites, several of which are the market leaders. The flagship site Amazon.com is ranked as the #11 website in the world in terms of traffic by Alexa,

Cash Flows and Land
Words: 603 Length: 2 Document Type: Research Paper

Financial Calculations The Pickens Mining company has to make a decision with respect to whether or not it wants to develop a strip mine. Doing this is to fulfill a contract that it does not currently have. The decision needs to be based on careful analysis of the different cash flows, ensuring that only those incremental to this decision are included. In a capital budgeting situation, only the incremental cash flows

Financial Analysis of Medassets Company
Words: 2111 Length: 8 Document Type: Term Paper

By May 2012, MedAssets long-term debts are approximately $959.94 Million. Additionally, MedAssets secures loans that carry interest rates. With significant amount of loans that the company has secured and notes that the company has issued, the company faces interest rates risks. To mitigate the effect of risks associated with the fluctuation of the interest rates, the company enters into the series of financial instrument to guide against the risks from

Sign Up for Unlimited Study Help

Our semester plans gives you unlimited, unrestricted access to our entire library of resources —writing tools, guides, example essays, tutorials, class notes, and more.

Get Started Now