Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please solve the table below and show all formulas used. thanks B D E F G H 1 j J K K L M N

please solve the table below and show all formulas used. thanks

image text in transcribed

image text in transcribed

image text in transcribed

B D E F G H 1 j J K K L M N for all problems tional Property Class 10 years raw augmentation if multiple equipment purchases &> 1 properly class nd can be hidden to make printable region cover a 10-vear project life Problem 12-26: $120.000 capital cost: 40% Bonus Deprec: 5 year Property Class: 22% combined tax rate: $32 000 amal cash flow Sur5-S40 000 MARR=12% MACRS Depreciation Rates 0 2 3 4 5 6 7 10 3-year Property Class & Rates 3 0.3333 0.4444 0.1487 OT0741 5-vear Property Class & Rates 5 0.2000 0.32000.1920 0.1152 0.1152 0.0576 7-ear Property Class & Rates 7 0.1429 0.2449 0.1749 0.1249 0.0892 0.0892 0.0892 0.0446 10-year Property Class & Rates 10 0.1000 0.18000.1440 0.1152 0.09220.0737 070655 0.0655 0.06550655 15-vear Property Class Rate 15 0.0500 0.0950 0.0855 0.07700.0593 0.0623 0.0590 0.05900.0502 0.0602 20-year Property Class & Rates 20 0.0375 0.0722 0.0668 0.0618 0.0571 0.0528 0.0489 0.04520.0446 0.0446 1 2 3 4 5 6 7 8 9 in 11 12 13 14 15 16 17 18 19 2n 21 22 23 24 25 26 27 0 0 0 Depreciation Expense & EOY Book Value Initial Capital Cost Bonus Depreciation Cost Basis MAORS Depreciation Expense Note: vee 50% of MACRS rate in year of sale End-of-Year Book Value 8) 1 40000 Asset Disposal (Assuming no capital gains) SV (Selling Price) EOY Book Value Ordinary Income Gain Loss 28 nly 29 31 32 24 L U - U 11 - c 1 ter Tax Project Evaluation Worksheet Template 2 ste Import calculation results from the Depreciation and Depletion worksheet templates 3 ste: Not all rows will be needed for all problems 4 ite: Will need calumn augmentation if study period 10 years 5 ste Column A is for reference and can be hidden to make printable region cover a 10-year project life 6 7 Problem 12-26: $120,000 capital cost: 40% Bonus Deprec: 5-year Property Class; 22% combined tax rate $32, 8 000 annual cash flow MARR-12% 9 Combined Marginal Tax Rate in State Income Tax Rate(s) 11 Federal Income Tax Rate 12 Combined Tax Rates+ f(13) 0.22 13 MARR 0.12 14 15 INCOME TAX CALCULATION 0 1 2 3 4 5 165) Sales Revenue 17 7 Cash Expenses 18B) (16) - (17) Tax-Related Cash Flow 32000 199) import from worksheets Depreciation & Depletion Deduction 20 D) import from worksheet Ordinary Gains/Losses (SV-BV) 0 0 0 0 211) (18)-(19) +/- (20) Taxable income 22 2) - ($c$1221) Income Taxes 223) (21)-(22) Income after Taxes 24 25 AFTER TAX CASH FLOW CALCULATION 0 2 3 5 26 5) Initial Costs (Equipment, Land, Minerals) 277) (18) Tax-Related Cash Flow 28 B) Equipment Sales (SV)-import from worksheet 299) - (22) Income Taxes 30 D) - (27) + (28)-(29) - (26) After-Tax Cash Flow (ATCF) 31 AFTER TAX CASH FLOW PROJECT EVAL 32 PV[C13 D30 H30)-C26 After-Tax NPV 23 RC30 H30) After Tax IRR Was Investment Satisfactory? 25 36 37 38 an 41 42 4 24 12-26 A mining corporation purchased $120,000 of production machinery and depreciated it using 40% bonus depreciation with the balance using 5-year MACRS depreciation, a 5-year depreciable life, and zero salvage value. The corporation is a profitable one that has a 22% combined incremental tax rate. At the end of 5 years the mining company changed its method of operation and sold the production machinery for $40,000. During the 5 years the machinery was used, it reduced mine operating costs by $32,000 a year, before taxes. If the company MARR is 12% after taxes, was the investment in the machinery a satisfactory one? B D E F G H 1 j J K K L M N for all problems tional Property Class 10 years raw augmentation if multiple equipment purchases &> 1 properly class nd can be hidden to make printable region cover a 10-vear project life Problem 12-26: $120.000 capital cost: 40% Bonus Deprec: 5 year Property Class: 22% combined tax rate: $32 000 amal cash flow Sur5-S40 000 MARR=12% MACRS Depreciation Rates 0 2 3 4 5 6 7 10 3-year Property Class & Rates 3 0.3333 0.4444 0.1487 OT0741 5-vear Property Class & Rates 5 0.2000 0.32000.1920 0.1152 0.1152 0.0576 7-ear Property Class & Rates 7 0.1429 0.2449 0.1749 0.1249 0.0892 0.0892 0.0892 0.0446 10-year Property Class & Rates 10 0.1000 0.18000.1440 0.1152 0.09220.0737 070655 0.0655 0.06550655 15-vear Property Class Rate 15 0.0500 0.0950 0.0855 0.07700.0593 0.0623 0.0590 0.05900.0502 0.0602 20-year Property Class & Rates 20 0.0375 0.0722 0.0668 0.0618 0.0571 0.0528 0.0489 0.04520.0446 0.0446 1 2 3 4 5 6 7 8 9 in 11 12 13 14 15 16 17 18 19 2n 21 22 23 24 25 26 27 0 0 0 Depreciation Expense & EOY Book Value Initial Capital Cost Bonus Depreciation Cost Basis MAORS Depreciation Expense Note: vee 50% of MACRS rate in year of sale End-of-Year Book Value 8) 1 40000 Asset Disposal (Assuming no capital gains) SV (Selling Price) EOY Book Value Ordinary Income Gain Loss 28 nly 29 31 32 24 L U - U 11 - c 1 ter Tax Project Evaluation Worksheet Template 2 ste Import calculation results from the Depreciation and Depletion worksheet templates 3 ste: Not all rows will be needed for all problems 4 ite: Will need calumn augmentation if study period 10 years 5 ste Column A is for reference and can be hidden to make printable region cover a 10-year project life 6 7 Problem 12-26: $120,000 capital cost: 40% Bonus Deprec: 5-year Property Class; 22% combined tax rate $32, 8 000 annual cash flow MARR-12% 9 Combined Marginal Tax Rate in State Income Tax Rate(s) 11 Federal Income Tax Rate 12 Combined Tax Rates+ f(13) 0.22 13 MARR 0.12 14 15 INCOME TAX CALCULATION 0 1 2 3 4 5 165) Sales Revenue 17 7 Cash Expenses 18B) (16) - (17) Tax-Related Cash Flow 32000 199) import from worksheets Depreciation & Depletion Deduction 20 D) import from worksheet Ordinary Gains/Losses (SV-BV) 0 0 0 0 211) (18)-(19) +/- (20) Taxable income 22 2) - ($c$1221) Income Taxes 223) (21)-(22) Income after Taxes 24 25 AFTER TAX CASH FLOW CALCULATION 0 2 3 5 26 5) Initial Costs (Equipment, Land, Minerals) 277) (18) Tax-Related Cash Flow 28 B) Equipment Sales (SV)-import from worksheet 299) - (22) Income Taxes 30 D) - (27) + (28)-(29) - (26) After-Tax Cash Flow (ATCF) 31 AFTER TAX CASH FLOW PROJECT EVAL 32 PV[C13 D30 H30)-C26 After-Tax NPV 23 RC30 H30) After Tax IRR Was Investment Satisfactory? 25 36 37 38 an 41 42 4 24 12-26 A mining corporation purchased $120,000 of production machinery and depreciated it using 40% bonus depreciation with the balance using 5-year MACRS depreciation, a 5-year depreciable life, and zero salvage value. The corporation is a profitable one that has a 22% combined incremental tax rate. At the end of 5 years the mining company changed its method of operation and sold the production machinery for $40,000. During the 5 years the machinery was used, it reduced mine operating costs by $32,000 a year, before taxes. If the company MARR is 12% after taxes, was the investment in the machinery a satisfactory one

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

Securitisation Derivatives A Practioner's Handbook

Authors: Mark Aarons, Vlad Ender, Andrew Wilkinson

1st Edition

1119532272, 978-1119532279

More Books

Students also viewed these Finance questions

Question

Question in Chemical Engineering Please Write Correct answer 7 .

Answered: 1 week ago

Question

List behaviors to improve effective leadership in meetings

Answered: 1 week ago