how to develope this spreadsheet for economic evaluation ?
0 Years Revenue Cash Expense Book Depreciation 3100,000.00 3120,000.00 3140,000.00 $150,000.00 1150,000.00 $50,000.00 380,000.00 370.000.00 375.000 375 00 00 Book Income Pro-Tex Book Tax at 32% After Tax Book Income Financial Measures Profit Marin % Net Assets ROA % $100,000.00 Cashflow Revenue Cash Expense Tax Depreciation Pretax Income Tax at 32% After Tax Income After Tax Cashtlow Cumulative Cashflow Payback Period Present Worth 10 PV12 PW15 IRR Part of the course requirements include developing a spreadsheet which can be used for project evaluations. The following template will be used: Our sawmill is planning a $100,000.00 addition to accommodate increased furniture and particle board production. We have a five year write off for tax depreciation. The income tax rate is 32%. Revenue and expenses are indicated in the spread sheet given below. Your assignment is to complete the spreadsheet, determine the cash flows, and evaluate the merit of facility expansion. wver the use of this ratio in Lesson 8. Spreadsheet Development Part of the course requirements include developing a spreadsheet which can be used for project evaluations. The following template will be used: Our sawmill is planning a $100,000.00 addition to accommodate increased furniture and particle board production. We have a five year write off for tax depreciation. The income tax rate is 32%. Revenue and expenses are indicated in the spread sheet given below. Your assignment is to complete the spreadsheet, determine the cash flows, and evaluate the merit of facility expansion. 0 Years Revenue Cash Expense Book Depreciation 1 2 3 5 $100,000.00 $120.000,00 5140,000.00 $150,000.00 $150,000.00 350.000 DO 360,000.00 $70,000.00 375,000.00 575000.00 Book Income Pro-Tex Book Tax al 32% After Tax Book Income Financial Measures Proft Mergin% 3100,000.00 Net Assets ROA Cashflow Revenue Cash Expense Text Depreciation Pretancome Ater Tax income After Too Cum Catho Payback Period ERR Based on your previous work, this exercise will be similar to the spreadsheet that you have developed so far except for the Financial Measures and Efficiency Measures that are shown in the template. a 0 Years Revenue Cash Expense Book Depreciation 3100,000.00 3120,000.00 3140,000.00 $150,000.00 1150,000.00 $50,000.00 380,000.00 370.000.00 375.000 375 00 00 Book Income Pro-Tex Book Tax at 32% After Tax Book Income Financial Measures Profit Marin % Net Assets ROA % $100,000.00 Cashflow Revenue Cash Expense Tax Depreciation Pretax Income Tax at 32% After Tax Income After Tax Cashtlow Cumulative Cashflow Payback Period Present Worth 10 PV12 PW15 IRR Part of the course requirements include developing a spreadsheet which can be used for project evaluations. The following template will be used: Our sawmill is planning a $100,000.00 addition to accommodate increased furniture and particle board production. We have a five year write off for tax depreciation. The income tax rate is 32%. Revenue and expenses are indicated in the spread sheet given below. Your assignment is to complete the spreadsheet, determine the cash flows, and evaluate the merit of facility expansion. wver the use of this ratio in Lesson 8. Spreadsheet Development Part of the course requirements include developing a spreadsheet which can be used for project evaluations. The following template will be used: Our sawmill is planning a $100,000.00 addition to accommodate increased furniture and particle board production. We have a five year write off for tax depreciation. The income tax rate is 32%. Revenue and expenses are indicated in the spread sheet given below. Your assignment is to complete the spreadsheet, determine the cash flows, and evaluate the merit of facility expansion. 0 Years Revenue Cash Expense Book Depreciation 1 2 3 5 $100,000.00 $120.000,00 5140,000.00 $150,000.00 $150,000.00 350.000 DO 360,000.00 $70,000.00 375,000.00 575000.00 Book Income Pro-Tex Book Tax al 32% After Tax Book Income Financial Measures Proft Mergin% 3100,000.00 Net Assets ROA Cashflow Revenue Cash Expense Text Depreciation Pretancome Ater Tax income After Too Cum Catho Payback Period ERR Based on your previous work, this exercise will be similar to the spreadsheet that you have developed so far except for the Financial Measures and Efficiency Measures that are shown in the template. a
