Question: SOLVE THE QUESTION ON EXCEL AND SHOW FORMULAS!!! Given the following - information provide an analysis that answers the questions at the end of the

SOLVE THE QUESTION ON EXCEL AND SHOW FORMULAS!!!

Given the following - information provide an analysis that answers the questions at the end of the assignment. Purchase Price: $8,625,000 NOI Growth Rate: 3.15% Loans LTV: 60% Amortization Period: 25 years, Term: 7 years Interest Rate: 4.75% Lender Points: 1.25% Selling Costs: 3\%: Going Out Cap Rate. 6.45% Discount Rate: 12% Questions: 1. What is the going in cap rate? 2. What is year 1PGI ? 3. What is the DSCR? 4. What is your initial investment? 5. What is the sale price after the five-year hold? 6. What is the loan balance at sale? 7. What is the NPV for this project? 8. What is the IRR for this project? 9. What is the DCF for this project? 10. What is the reversion amount? Please show your work in an Excel file (meaning use the Excel functions), highlighting yours answers for Part 1 and provide a question an Given the following - information provide an analysis that answers the questions at the end of the assignment. Purchase Price: $8,625,000 NOI Growth Rate: 3.15% Loans LTV: 60% Amortization Period: 25 years, Term: 7 years Interest Rate: 4.75% Lender Points: 1.25% Selling Costs: 3\%: Going Out Cap Rate. 6.45% Discount Rate: 12% Questions: 1. What is the going in cap rate? 2. What is year 1PGI ? 3. What is the DSCR? 4. What is your initial investment? 5. What is the sale price after the five-year hold? 6. What is the loan balance at sale? 7. What is the NPV for this project? 8. What is the IRR for this project? 9. What is the DCF for this project? 10. What is the reversion amount? Please show your work in an Excel file (meaning use the Excel functions), highlighting yours answers for Part 1 and provide a question an

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!

I am reposting this because i got incorrect answer. I posted other parts of this question as seperate. MUST SHOW WORK IN EXCEL. Part 2 - NPV & IRR Given the following information provide an analysis...

Part 2 - NPV & IRR Given the following information provide an analysis that answers the questions at the end of the assignment. Purchase Price: $4,735,000 Rents: Tenant Unit 1 Unit 2 Unit 3 Unit 4...

can you help me solve these questions on excel please Given the following information provide an analysis that answers the questions at the end of the assignment. Purchase Price: $4,250,000 Rents:...

please help Q2 Given the following information, calculate the net operating income assuming below-line treatment of capital expenditures: Property: 10 office units, Contract rents per unit: $2,500...

please help Part 1 - Income Approach Q1 Given the following information calculate the overall capitalization rate: Sale price: $3,250,000; Potential gross income: $255,000; Vacancy and collection...

Part 1 - Income Approach Q1 Given the following information, calculate the overall capitalization rate: Sale price: $6,250,000; Potential gross income: $467,250; Vacancy and collection losses: 5.5%;...

Given the following information provide an analysis that answers the questions at the end of the assignment. Purchase Price: $4,250,000 Rents: Tenant Unit 1 Unit 2 Unit 3 Unit 4 Unit 5 Unit 6 Unit 7...

Given the following information provide an analysis that answers the questions at the end of the assignment. Purchase Price: $4,100,000 Rents: Tenant Unit 1 Unit 2 Unit 3 Unit 4 Unit 5 Unit 6 Unit 7...

Given the following information provide an analysis that answers the questions at the end of the assignment. Purchase Price: $7,890,410 Rents: Tenant Unit 1 Unit 2 Unit 3 Unit 4 Unit 5 Unit 6 Unit 7...

A $60 par value preferred stock has a stated dividend of 6%, with a market price of $70. The company plans on raising cash in the market by selling more of the same preferred stock and investment...

Evaluate the following determinant by using row-operations. Carefully label all steps. -1 4 -2 -6 -10 -4 A = -3 -2 -4 -8 2 1 9. 6

Identify the principles of internal control by selecting the correct answers below. Match revenues with expemes in the same accounting period. Foiform reguts and independent teviewt. Maintalin...

9. (15 points) A company is considering a new project that requires an investment of \$5 million. The project is expected to generate cash flows of $2 million in year 1,$3 million in year 2, and $4...

Identify conflict triggers in yourself and others

3. As a new romantic relationship begins, keep a journal of the communication events that occur. In this journal, indicate the stage you perceive the relationship to be in (based on the stages in...

2. Consider a romantic relationship that has ended. Using the stages outlined in this chapter, create a time line of the relationship. Include significant communication episodes that encouraged the...