Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Calculations must be done in Excel - You must generate your own spreadsheet This question should be done using these instructions ?Table One: Calculate the

Calculations must be done in Excel - You must generate your own spreadsheet

This question should be done using these instructions

?Table One: Calculate the impact on taxable income (TI) and then the tax cash flows

?Table Two: Set out all the cash flows to calculate NCFAT

For example :

image text in transcribed
Beginners Method (two tables one for tax and one for cash flows) TAX 0 2 3 Microsoft Office Excel Worksheet Cash Benefits 16,000 20,000 12,000 Inv Allow 20% -5,600 Deprec -11,200 -6,720 -4,032 Loss on Sale -5,548 Taxable Income -800 13,280 2,420 Tax @, 30% 240 -3,984 726 Cash Flows N 3 Tax 240 -3,984 -726 Cash Benefits 16,000 20,000 12,000 Salvage Value 500 Outlay -28,000 NCFAT -28,000 16,240 16,016 11,774 DCF @ 15% 28,000 14,122 12,110 7,742 NPV 5,974

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

Mathematics For Business

Authors: Stanley A Salzman, Charles D Miller, Gary Clendenen

8th Edition

0321357434, 9780321357434

More Books

Students also viewed these Finance questions

Question

13. Give four examples of psychological Maginot lines.

Answered: 1 week ago