Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

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

Becker CPA Exam Final Review Auditing

Authors: Becker

1st Edition

1943628521, 978-1943628520

More Books

Students also viewed these Accounting questions

Question

What are some of the possible scenes from our future?

Answered: 1 week ago