Create a spreadsheet that shows projected revenue and expenses for the Hannson Expansion for 2009-2018. You may reference the Heru case spreadsheet for guidance, as well as the attached template.

The submission should have cash flow, NPV and IRR calculations. This assignment will count as 40 points. The remaining project will be worth 60 points.

Please note: Late work on this assignment will not be accepted.

Excel Sheet Template: Hansson Template REV.xlsxPreview the documentView in a new window

Units Unit Costs 48000 094 2013 $84.960.00 $93,88100 $103,124.00 $112,70000 S122,618.00 New Project 2009 2010 Exhibit 5 Exhibit 5 Revenue $132 887.00 S13: Cost to Expand Interest Exp Production Expenses 1% Raw Materials 45120 3600 2250 3.00% Manufacturing Overhead 3% Maintenance Expense Tax Rate Exhibit S 5 Labor E 8640 6626.88 76236.88 8723.12 7.80%Selling General and Admin . Total EBITDA NPV Discount 93881 103124 112700 122618 132887 Flat EBIT 8723.12 93881 103124 112700 122618 132887 Flat Imterest Expense EBT 8723.12 93881 103124 112700 122618 3288 Calc Net Profit 8723.12 3881 103124 112700 122618 32887 Flat Add Depreciation Total Cash Flow $8,723.12 $93,881.00 $103,124.00 $112,700.00 $122,618.00$132,88700$13 NPV and IRR Calculations Units Unit Costs 48000 094 2013 $84.960.00 $93,88100 $103,124.00 $112,70000 S122,618.00 New Project 2009 2010 Exhibit 5 Exhibit 5 Revenue $132 887.00 S13: Cost to Expand Interest Exp Production Expenses 1% Raw Materials 45120 3600 2250 3.00% Manufacturing Overhead 3% Maintenance Expense Tax Rate Exhibit S 5 Labor E 8640 6626.88 76236.88 8723.12 7.80%Selling General and Admin . Total EBITDA NPV Discount 93881 103124 112700 122618 132887 Flat EBIT 8723.12 93881 103124 112700 122618 132887 Flat Imterest Expense EBT 8723.12 93881 103124 112700 122618 3288 Calc Net Profit 8723.12 3881 103124 112700 122618 32887 Flat Add Depreciation Total Cash Flow $8,723.12 $93,881.00 $103,124.00 $112,700.00 $122,618.00$132,88700$13 NPV and IRR Calculations