Question: A developer has put together a business plan to construct a retail structure with the following Pro Forma information: Adjusted Gross Income, Annual: $540,000 Estimated

retail structure with the following Pro Forma information: Adjusted Gross Income, Annual:

A developer has put together a business plan to construct a retail structure with the following Pro Forma information: Adjusted Gross Income, Annual: $540,000 Estimated Expenses, Annual: $172,000 Planned Rate of Return: 13% The developer is looking to obtain a longterm loan from a bank to cover the construction of the retail structure. After assessing the developer's credit worthiness, the bank assigns the developer an interest rate of 8.0%. The bank will limit the loan at a ratio 75%, Loan Value to Economic Value. Please build a spreadsheet (similar to the model on page 202) and answer the following questions: - What is the computed Cap Rate that will be used in computations of the Economic (Capitalization) Value? - What is the Economic (Capitalization) Value of the Project? - What is the maximum loan value the bank will be willing to lend based on all of these factors

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

A developer has put together a business plan to construct a retail structure with the following Pro Forma information: Adjusted Gross Income, Annual: $540,000 Estimated Expenses, Annual: $172,000...

I need help solving this lab. I tried to work on it and have solved some of it, so I want to see if its right and how to solve the rest. It connects to lab 1, 4, and 6. I hahe posted all of the...

i got 7 questions in the assignment in the PDF file on P16-17 They are all about the case story The total of the words are 1500 words without any format QUEENSLAND UNIVERSITY OF TECHNOLOGY QUT...

Which of the five CPRs should Doug Scovanner accept? Be prepared to explain how each of the considerations that follow influenced your decision: (Please Give Explanation and COMPUTATION) a.NPV and...

This is a case study for financial planing course. there is a list of 18 questions at the end, only 5 are required. whichever questions you feel most confident answering. ik the cheg limit is 3 parts...

Please review the historical performance and projections on the Home Depot Value Line page, the spreadsheet, and the pro forma balance sheet and income statement. Submit a complete thorough ANALYSIS...

The car rental business was affected by general economic conditions and more particularly by conditions in the travel industry, especially airline traffic. There was a high correlation between...

Bidding for Hertz: Leveraged Buyout Overview In late summer 2005, Greg Ledford, managing director and head of automotive and transportation buyouts at the Carlyle Group, found himself examining his...

Using the scenarios in case Exhibit 9, what role does leverage play in affecting the return on equity (ROE) for CPK? What about the cost of capital? In assessing the effect of leverage on the cost of...

MPS, Inc. has the following unadjusted account balances as of December 31, 2015, the companys year- end: Cash: $ 430,000 Accounts Receivable: $ 2,000 Prepaid Insurance: $ 14,000 Prepaid Rent: $...

Economically, is it important to distinguish between single-family homes and other types of existing homes? Explain.

9 . When auditing inventory, which of the following procedures would the auditor least likely perform? Please add checkmark next to the correct answer ( s ) . 1 Observe the physical inventory count...

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...