Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I finished the pro forma for the strip mall and I have the right answers, but now I need to do income taxes/EATCF. Not sure

I finished the pro forma for the strip mall and I have the right answers, but now I need to do income taxes/EATCF. Not sure how to find that.

image text in transcribedimage text in transcribed

ol 2 S 3,974,690.89 (198,734.54) $ $ $ $ $ $ S $ $ Pro Forma Answers Potential Gross Income Vacancy & Collection Losses Other Incomel Rental Concessions Effective Gross Income Operating Expenses Expense Recoveries Net Operating Income Capital Expenditures Operating Cash Flow Resale Price Selling Expenses Reversion Cash Flow Property-Before-Tax Cash Flow Debt Service EBTCF Income Tax 3,775,956.35 943,989.09 471.994 54 1 3,600,000.00 S (1,800,000.00) $ $ S 1,800,000.00 $ (720,000.00) $ $ 1,080,000.00 $ (1,200,000.00) 5 (120,000.00) $ $ $ S (120.000.00) S 280,800.00 (400,800.00) $ 3,672,000.00 $ (183,600.00) $ $ $ 3,488,400.00 $ 872,100.00 S 436,050.00 $ 3,052,350.00 $ (152,617.50) $ 2,899,732.50 $ S 3,303,961.80 3,745,440.00 $ (187,272.00) $ S $ 3,558,168.00 $ 889,542.00 $ 444,771.00 $ 3,113,397.00 $ (155,669.85) $ 2,957,727.15 $ S $ S 2,957,727.15 S 280,800.00 2,676,927.15$ 5 3,896,755.78 $ (194,837.79) $ $ S 3,701,917.99 $ 925,479.50 S 462,739.75 S 3,239,178.24 S (161,958.91) 3,077,219.33 S 47,199,454.34 2,359,972.72 44,839,481.62 47,916,700.95 $10,309,371.43 37,607,329.52 3,820,348.80 $ (191,017.44) $ S $ 3,629,331.36 $ 907,332.84 $ 453,666.42 $ 3,175,664.94 $ (158,783.25) $ 3,016,881.69 $ $ $ $ 3,016,881.69 $ 280,800.00 2,736,081.69 $ 3,303,961.80 S $ $ $ S S 2,899,732.50 $ 280,800.00 2,618,932.50 $ $ In Homework Assignment #5, you created a pro forma from PGI to EBTCF. You showed it to your biggest investor. He has some follow-up questions on behalf of all your investors. To answer these questions, you can begin with the Answer Key that was posted online for the previous assignment. 1. We pay approximately 30% of our income in taxes. How much EATCF should we expect to earn each year from this investment? In order to answer this first question, you check with the county assessor, and they inform you that the building is worth 75% of the total property value. You can assume capital gains taxes and accumulated depreciation taxes add up to $10 million. 2. We want to earn a return of at least 12% before taxes. What is our NPV? What is our IRR? 3. My buddies at the Jonathan Club keep asking me about "multiples." What should I tell them? What kind of multiples can you calculate for me? Do they change every year, or should I just say one? 4. The seller is getting cold feet. They heard that we're planning to turn the mall into offices, and they suspect it's going to become worth a lot more than it is now. Can you recalculate all of the numbers above with a property price of $40 million? Should this change our plans

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_2

Step: 3

blur-text-image_3

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

Financial Markets And Institutions

Authors: Jeff Madura

10th Edition

1285531507, 9781285531502

More Books

Students also viewed these Finance questions