Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can you make a spreadsheet for it Thank you!!! You purchased a property for $1,000,000. Twenty percent of the purchase price represents land. The depreciable

Can you make a spreadsheet for it Thank you!!! image text in transcribed
You purchased a property for $1,000,000. Twenty percent of the purchase price represents land. The depreciable life of the asset is 40 years. Y The cap rate at purchase was 5%. NOI increases 10% per year. The cap rate at sale in five years is 4%. Fifty percent of the purchase price is debt. The debt has an interest rate of 4% per annum and you must repay $25,000 in principal at the end of each year. The balance of the purchase price, and initial cash to operate the business come from the sale of six partnership units at $100,000. The tax rate on income is 35%, on Recapture is 25% and on Capital Gains is 20%. Assume all cash is distributed to investors in the year in which it is earned. What is the IRR (after Tax) on the partnership's equity investment

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals of Investments Valuation and Management

Authors: Bradford D. Jordan, Thomas W. Miller

5th edition

978-007728329, 9780073382357, 0077283295, 73382353, 978-0077283292

More Books

Students also viewed these Finance questions

Question

1.Which are projected Teaching aids in advance learning system?

Answered: 1 week ago

Question

What are the classifications of Bank?

Answered: 1 week ago