5. Use the MACRS tables and the Tax Analysis Spread Sheet as discussed in class
ID: 2600456 • Letter: 5
Question
5. Use the MACRS tables and the Tax Analysis Spread Sheet as discussed in class Same as Chapter 10 in book), that is, show Before Tax Cash Flow, Depreciation, Taxable Income, Taxes, and After-Tax Cash Flow for each year) to apply to the following: An amusement park ride. Annual NET revenue AFTER TAXES is 70,000. Color Orange. Tax Rate 0.4. No borrowed Money. Salvage Value at 30 years: 10,000. Location USA. Name of Ride STAR WARS ADVENTURE. Initial cost 400,000. Owners' dog name Frank. In the interests of time, Show values for first five years only.Explanation / Answer
As per the MACRS depreciation system provided by IRS, “Amusement Park Assets” fall under the General Depreciation System Class life of 27.5 years. The below table shows the MACRS schedule for such assets:
Depreciation rate for Year 1 = 3.485%
Depreciation rate for Year 2 to Year 9 = 3.636%
MACRS Depreciation Schedule
Year
Basis
Depreciation Rate
Depreciation Expense
Accumulated Depreciation
Ending Book Value
1
$390,000.00
3.485%
$13,591.50
$13,591.50
$386,408.50
2
$390,000.00
3.636%
$14,180.40
$27,771.90
$372,228.10
3
$390,000.00
3.636%
$14,180.40
$41,952.30
$358,047.70
4
$390,000.00
3.636%
$14,180.40
$56,132.70
$343,867.30
5
$390,000.00
3.636%
$14,180.40
$70,313.10
$329,686.90
Note: Since the salvage value at 30 years is 10,000, the basis for depreciation will be $390,000.
Year
1
2
3
4
5
Before-tax Cash Flow
$130,258.17
$130,847.07
$130,847.07
$130,847.07
$130,847.07
Depreciation
$13,591.50
$14,180.40
$14,180.40
$14,180.40
$14,180.40
Taxable Income
$116,666.67
$116,666.67
$116,666.67
$116,666.67
$116,666.67
Tax @ 40%
$46,666.67
$46,666.67
$46,666.67
$46,666.67
$46,666.67
After-tax Net Revenue
$70,000.00
$70,000.00
$70,000.00
$70,000.00
$70,000.00
Workings:
Since tax rate is 40%, after-tax net revenue is 60% of total taxable income. So, the Taxable income would be:
Taxable Income = (After-tax Net Revenue/60)*100 = $116,666.67
Tax @ 40% = $116,666.67*40% = $46,666.67
Depreciation = As calculated in the given table
Before-tax cash flow = Taxable Income + Depreciation
MACRS Depreciation Schedule
Year
Basis
Depreciation Rate
Depreciation Expense
Accumulated Depreciation
Ending Book Value
1
$390,000.00
3.485%
$13,591.50
$13,591.50
$386,408.50
2
$390,000.00
3.636%
$14,180.40
$27,771.90
$372,228.10
3
$390,000.00
3.636%
$14,180.40
$41,952.30
$358,047.70
4
$390,000.00
3.636%
$14,180.40
$56,132.70
$343,867.30
5
$390,000.00
3.636%
$14,180.40
$70,313.10
$329,686.90
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.