Answered step by step
Verified Expert Solution
Question
1 Approved Answer
ALL NUMBERS SHOWN IN PICTURE ARE CORRECT. I want to know how they got those numbers, please show all your work, if you use excel
ALL NUMBERS SHOWN IN PICTURE ARE CORRECT. I want to know how they got those numbers, please show all your work, if you use excel please show all your formulas, THANK YOU.
On March 25, 2015, John Rebel acquired a commercial building as a short term investment. He paid $1,800,000 for it, of which $290,000 was the value of the land it was on. He plans to sell the property in July 2018 at an estimated price of $2,300,000. During the onwership, he will lease out the building for $190,000 per year. The prorated lease revenues for the years 2015 and 2018 are $142,500 and $95,000, respectively Using the MACRS method of depreciation for tax purpouses. determine the after-tax cash flows for each of the years he owns the building, including the after-tax cash flow from sale of the building in 2018 Note that the income tax rate rate for John is 33% and the capital gain tax rate is 15% The ATCF from the rental income for the year 2015 - $ 105590 (Round to the nearest dollar) The ATCF from the rental income for the year 2016- $ 140077 (Round to the nearest dollar) The ATCF from the rental income for the year 2017H $ 140077 (Round to the nearest dollar) The ATCF from the rental income for the year 2018 $705 (Round to the nearest dollar) The ATCF from the sale of the property in 2018 -$ 2205641 (Round to the nearest dollar)Step 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