Estimate cash flows from operations and eventual sale

Assignment Help Finance Basics
Reference no: EM131326626

As a financial advisor for the Spain Development Co., you have been given the construction and marketing studies for the proposed Timbercreek office project. Several potential sites have been selected, but a final decision has not been made. Your manager needs to know how much she can afford to pay for the land and still manage to return 16 percent on the entire project over its lifetime. The strategic plan calls for a construction phase of one year and an operation phase of five years, after which time the property will be sold.

The marketing staff says that a 1.3-acre site will be adequate because the initial studies indicate that this site will support an office building with a gross leasable area (GLA) of 26,520 square feet. The gross building area (GBA) will be 31,200 square feet, giving a leasable ratio of 85 percent. The marketing staff further assures you that the space can be rented for $19 per square foot. The head of the construction division maintains that all direct costs (excluding interest carry and all loan fees) will be $2.4 million.

The First Street Bank will provide the construction loan for the project. The bank will finance all of the construction costs, site improvements, and interest carry at an annual rate of 13 percent plus a loan origination fee of 1.5 points. The construction division estimates that the direct cost draws will be taken down in six equal amounts commencing with the first month after close. The permanent financing for the project will come at the end of the first year from the Reliable Co. at an interest rate of 11.5 percent with a 4 percent prepaid loan fee.

The loan has an eight-year term and is to be paid back monthly over a 25-year amortization schedule. No financing fees will be included in either loan amount. Spain will fund acquisition of the land with its own equity. Spain expects tenant reimbursements for the project to be $3.25 per square foot and the office building to be 75 percent leased during the first year of operation.

After that, vacancies should average about 5 percent of GPI per year. Rents, tenant reimbursement, and operating expenses are expected to increase by 3 percent per year during the lease period. The operating expenses are expected to be $9.50 per square foot. The final sales price is based on the NOI in the sixth year of the project (the fifth year of operation) capitalized at 9.5 percent. The project will incur sales expenses of 4 percent. Spain is concerned that it may not be able to afford to pay for the land and still earn 16 percent (before taxes) on its equity (remember that the land acquisition cost must be paid from Spain's equity). To consider project feasibility,

a. Estimate the construction draw schedule, interest carry, and total loan amount for improvements. Determine total project cost (including fees) less financing and the equity needed to fund improvements.

b. Estimate cash flows from operations and eventual sale.

c. Establish whether a positive or negative NPV exists by discounting equity cash inflows and outflows in (b).

d. What does the NPV mean in this case? If the asking price of the land were $195,000, would this project be feasible?

Reference no: EM131326626

Questions Cloud

What will be the total project cost for parker road plaza : What will be the total project cost for Parker Road Plaza (excluding loan commitment fees and interest carry)? What will be the total direct costs?
Discuss the diagnostic statistical manual : Refer to the Diagnostic Statistical Manual of Mental Disorders (DSM-5) or your class textbook and choose two co-occuring disorders of interest.discuss the following for each disorder selected: prevalence rate, etiology, prognosis, and most efficaci..
Formation of multicultural teams : Do you think that PepsiCo's encouragement of employee networks actually works against diversity and the formation of multicultural teams? Why or why not?
Discuss any similar or opposing perspectives you have : MGT 435- Discuss any similar or opposing perspectives you have, with at least two of your peers. Take care to be professional and polite even if your beliefs or viewpoints differ.
Estimate cash flows from operations and eventual sale : Estimate cash flows from operations and eventual sale.- Establish whether a positive or negative NPV exists by discounting equity cash inflows and outflows in (b).
How to write cover letters video which include more info : Prior to beginning work on this discussion, review the Cover Letters PDF provided by the Ashford University Office of Career Services and the What Is a Cover Letter? and Writing the Dreaded Cover Letter online resources. It is recommended that ..
How might land development activities be specialized : How might land development activities be specialized? Why is this activity different from project development discussed.
Challenges of a manager in a learning organization : Many students of the Second City Training Center are businesspeople looking to gain skills for the corporate context. What skills from the world of improvisational comedy would be valuable to a business manager?
Why do lenders insist on loan repayment rates : In land development projects, why do lenders insist on loan repayment rates in excess of sales revenue? What is a release price?

Reviews

Write a Review

Finance Basics Questions & Answers

  Determine whether or not mvp should proceed with expansion

The firm would also make year-end principal payments of $2,333,333 million per year, completely retiring the issue by the end of the third year. Using the Adjusted Present Value (APV) method, determine whether or not MVP should proceed with the ex..

  Questions relating to discounted cash flow

Answer the following questions relating to Discounted Cash Flow (DCF) projections and valuations.

  What is the value of the land

A piece of land produces an income that grows by 5% per annum. If the first year's income is $10,000, What is the value of the land?

  Drive fluctuation in the short term stock market prices

Can you tell me what are the most important factors that drive the fluctuation in the short term stock market prices, and why do you think that they do drive short term securities price fluctuations?

  What is nathan''s tax liability from the event

Compare the total value of Nathan's stock holdings before and after the split, given that the price of General Mills stock immediately after the split was $37.50. What do you find? Does Nathan experience a gain or loss on the stock as a result of the..

  What will be its dividend payout ratio

If net income next year is $1.8 million and Perkin follows a residual distribution policy with all distributions as dividends, what will be its dividend payout ratio? Round your answer to two decimal places.

  You have been hired to be the new marketing manager for

you have been hired to be the new marketing manager for krispies cereal. in this business you are the manufacturer and

  What caused them to change during this time

how long were Robinson's operating cycles and cash conversion cycles in each of these years? what caused them to change during this time?

  Boehm incorporated is expected to pay a 150 per share

boehm incorporated is expected to pay a 1.50 per share dividend at the end of this year i.e. d1 1.50. the dividend is

  How will the reserve impact current earnings

The Jones Company is having a very good year with sales running 50% above projections. At the end of the year the CFO decides that this is a good time to provide for possible obsolete inventory and sets up a $15 million reserve account for obsolet..

  How professional venture capital got started after world war

Briefly describe how professional venture capital got started after World War II.

  All else constant if the default correlations between the

a standard synthetic cdo references a portfolio of 10 corporate names. assume the following. the total reference

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