Answered step by step
Verified Expert Solution
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.
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 plansStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started