Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Given the discount rate is 10%. Complete the net profit, net cash flow and paid tax. And use Excel to create a table on NPV

image text in transcribedGiven the discount rate is 10%. Complete the net profit, net cash flow and paid tax. And use Excel to create a table on NPV and discount rate
B c D E F G H Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 700 650 500 450 570 Initial plant Tax rate 1000 20% 50 130 20 200 80 170 20 200 40 140 20 200 60 190 20 200 70 150 20 200 400 470 400 470 440 1 Year 0 2 3 Sales Revenue 4 5 Costs: 6 Labour 7. Material 8 Overhead 9 depreciation 10 11 Total cost 12 13 Trading profit 14 Taxation 15 Net profit 16 Tax Paid 17 Net cash flow 18 19 NPV 20 JIRR 21 22 300 60 180 36 100 20 -20 0 130 26 -1000 Discount rate 10%

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

Financial Forensics Body Of Knowledge

Authors: Darrell D. Dorrell, Gregory A. Gadawski

1st Edition

0470880856, 978-0470880852

More Books

Students also viewed these Accounting questions

Question

Describe new developments in the design of pay structures. page 475

Answered: 1 week ago