Closed

Investment and Valuation Decision using DCF - Report and Excel

Background

Two investors (Mr X and Ms Y) request that you recommend an investment in either an

office building or an industrial/warehouse building in the Sydney region. The two investors

decide to jointly invest with a 60/40 share on all returns and costs of the property you

recommended. Assume they can jointly borrow 65 percent from a bank at an interest rate

of 6% for the investment. You are required to produce a report for the recommendation and

your fee for the recommendation is 1.5 per cent of the purchase price of the recommended

investment. A selection of these properties can be found from the links:

[url removed, login to view]

Requirements

In your report, you need to include the following details:  

1) How much should the buyers pay for the recommended property?  

Requirements: you need to use capitalisation rates method to estimate the property

value

2) What are the benefits and risks of the investment, a ten‐year investment term is

assumed?

a. You need to conduct a market study and find out the variables needed for

building a DCF model.    At least two tenancy agreement details with rent

reviews and incentive conditions are required. Appropriate assumptions can

be made.

b. You need to produce a ten‐year DCF model to support your recommendation;

c. You need to test sensitivity and scenario of the developed model to analyse

the risk involved.

3) Would the recommendation for a 15‐year investment be feasible? Why?  

a. You need to build a 15‐year DCF model to demonstrate this.

b. You need to conduct sensitivity and scenario analysis to analyse the risks they

may have involved.

4) What are the benefits for Investor Mr X (10 years investment is assumed)?

(Completed by Student A)

5) What are the benefits for investor Ms Y (15 years investment is assumed)?

(Completed by Student B)  

6) What are the benefits for the bank (the lender) (12‐year investment is assumed)?

(Completed by Student C)  

a. You need to build DCF models to support your discussion for 4) – 6).

b. You need to discuss the results.

Other assumptions  

 Adopt an interest only loan to be repaid at the end of the investment period.  

 Adopt a discount rate of 12% per annum.

 All costs and revenues provided are exclusive of GST.  

 You are not required to take GST into consideration for your solution.

You need to conduct your own research for all the required variables for developing DCF

models. The marking criteria are stated below for your reference.

Skills: Excel, Investment Research, Microsoft, Valuation & Appraisal

See more: how to calculate intrinsic value of a stock, intrinsic value calculator online, warren buffett intrinsic value excel, intrinsic value calculator xls, graham intrinsic value formula excel, how to calculate intrinsic value of a stock warren buffett, intrinsic value calculator excel template, stock valuation calculator excel free, monthly report excel using access data, monthly report excel using access, financial analysis investment report excel, generate report excel using php, export report excel using dynamicjasper, php report excel, design report excel 10g

About the Employer:
( 0 reviews ) Australia

Project ID: #15098878

20 freelancers are bidding on average $482 for this job

RRconsultant

Hi there, I am an expert in valuation and financial modeling and research with over 12 years experience in the filed. Keen to help you with the requirements. Look forward to hear from you. Thx, RRC Relevant Skills More

$685 AUD in 10 days
(20 Reviews)
5.2
$250 AUD in 2 days
(16 Reviews)
4.3
cyash61

We are an analytics consulting firm based in Mumbai. We will have an analyst and a lead assigned to the project and the delivery shall be 10 days from the date of awarding. [url removed, login to view] Relevant Skills and More

$555 AUD in 10 days
(2 Reviews)
3.5
$250 AUD in 1 day
(3 Reviews)
3.5
aanvikm

Hello Sir, This looks an interesting project and I am interested to do this research on investment and provide my detailed report as requested. Thanks Aanvik

$833 AUD in 10 days
(5 Reviews)
3.3
prateekmittal16

Hi I can prepare the investment and valuation analysis using the report for you. Please reach out to me for further discussions. Relevant Skills and Experience I am a qualified accountant and have more than 10 years o More

$750 AUD in 10 days
(1 Review)
3.0
$555 AUD in 10 days
(5 Reviews)
3.5
Ashisjena2015

A proposal has not yet been provided

$250 AUD in 5 days
(6 Reviews)
2.6
$250 AUD in 5 days
(6 Reviews)
2.7
palsetiavitesh

Hello Sir, I have done MBA with finance as my specialization. I am very strong in finance and accounting. I have experience in doing assignment related to finance and account at freelancer.com. Relevant Skills and E More

$250 AUD in 3 days
(3 Reviews)
2.3
tyroneroshan31

Dear sir i am new freelancer who wants to growth in this field. As a beginner i m not to expecting big mount payment for my service For any payment i can do your work. And I'm giving my full attention to your work. Pl More

$277 AUD in 2 days
(0 Reviews)
0.0
Rocky665

I'm interested to do this [url removed, login to view] me an opportunity to work with you. Relevant Skills and Experience MS Word, MS Excel, Photoshop, AutoCAD. Proposed Milestones $555 AUD - As per work.

$555 AUD in 10 days
(0 Reviews)
0.0
RubyOnRail

I have checked the requirement and I am clear with the scope. I have few questions on the description and would like to discuss this. Please initiate the communication, so we can discuss the project.

$833 AUD in 10 days
(0 Reviews)
0.0
Slavik159

A proposal has not yet been provided

$277 AUD in 5 days
(0 Reviews)
0.0
$722 AUD in 10 days
(0 Reviews)
0.0
WorkholicDays

I prepare various analytic Business Model using different financial tools for capital decision making either through NPV- DCF, PI, Capital Rationing and Multiple Finance Program. Bonds Discounting. Relevant Skills and More

$555 AUD in 10 days
(0 Reviews)
0.0
hernaufrago

Hello I'm an economist and I do valuations for investment funds required by the local regulator. I had work with a found that had different kinds of real estate assets on their portfolio such us office space, parking s More

$500 AUD in 14 days
(0 Reviews)
0.0
vishalkumar24

we have great experience in excel data mange and also have experience to apply formulas mare a appropriate result according to required details, so i can do all work that explained within project Relevant Skills and More

$333 AUD in 3 days
(0 Reviews)
0.0
$450 AUD in 4 days
(0 Reviews)
0.0
rupaksinghania

I am Chartered Accountant and Expert in financial Analysis. Project requires a lot of financial analysis. follow me on [url removed, login to view] Relevant Skills and Experience I have worke More

$500 AUD in 5 days
(0 Reviews)
0.0