Question: I need help figuring out how to fill in the blanks I have two questions that need to be answered as well Question 1) Net

I need help figuring out how to fill in the blanks

I have two questions that need to be answered as well

Question 1) Net Present Value of Net Operating Profit

Question 2) IRR of Net Operating Profit

as a bonus if there are any assumptions I can make let me know

Year 1Year 2Year 3Year 4Year 5
Incremental port revenue$0.00$ 136,932$ 287,557$ 234,154$ 91,881
Port margin61%61%61%61%
Port Profit Contribution$0.00
Revenue - SW Upgrades$0.00 10,000 22,000 22,000 2,000
SW Margin85%85%85%85%
SWProfit Contribution$0.00
Total revenue$0.00
Total Profit contribution$0.00
Effective Margin percent (profit/revenue)
Depreciation expense 75
Manufacturing overhead
20,540 43,134 35,123 13,782
Corporate overhead 24,922 52,335 42,616 16,722
Development expense 7,918 11,626
Maintenance expense 500 500 500
TOTAL EXPENSE 7,993
Pre-tax operating profit (7,993)
Taxes (3,037.34)
Net Operating Profit(4,955.66)

This what the speed sheet look like

I need help figuring out how to fill in the
Fill in thee blank cells Year Year Year Year 4 Year! ASSUMPTIONS Incremental port revenue $0.00 5 136,932 | $ 287,557 |$ 234,154 | S 91,881 Port margin 61% 61% 61 51% Capital Investments $300 in Year 1 and $469 in Year 2 iPort Profit Contribution $0.00 Depreciation Over 4 Years (25% per year) Tax Rate 38%% Revenue - SW Upgrades $0.00 10,000 22,000 22,000 2,000 Cost of Capital / Discount Rate 18% SW Margin 85%% 35% 85% 85% SW Profit Contribution $0.00 Total revenue $0.00 Total Profit contribution 50.00 Effective Margin percent (profit/revenue) Depreciation expense 75 Manufacturing overhead 20,540 43,134 35,123 13,782 Corporate overhead 24,922 52,335 42,616 16,722 Development 7,918 11,626 Maintenance expense 500 500 500 TOTAL EXPENSE 7,993 Pre-tax operating profit (7,993) Taxes (3,037.34) Net Operating Profit 14,955. ANSWER THE FOLLOWING QUESTIONS Net Present Value of Net Operating Profit IRR of Net Operating Profit

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!