|
|
| ACCT434/436 |
|
|
| Course Project |
|
|
| Elon Motors |
|
|
| Project Template |
|
|
|
| Elon Motors |
| Data: |
|
|
| Cost of new equipment |
$1,570,000.00 |
|
|
| Expected life of equipment in years |
12 |
|
|
| Salvage Value |
$70,000 |
|
|
| Life Production |
|
|
| Annual production or purchase needs |
|
|
| Number of workers needed |
|
|
| Annual hours to be worked per employee |
|
|
| Earnings per hour for employees |
|
|
| Health Benefits - % of Wages |
|
|
| Cost of Direct Materials |
|
|
| Variable Manufacturing Overhead Costs |
|
|
| Unit Cost to Purchase Batteries |
|
|
| Required rate of return |
|
|
| Tax rate |
|
|
|
| Make |
Purchase |
| Cost to Produce |
|
| Annual cost of direct material: |
|
|
| Need - Cost of direct material |
|
| Annual cost of direct labor for new employees: |
|
|
| Wages |
|
|
| Health benefits |
|
|
| Total wages and benefits |
|
| Other variable production costs |
|
| Total annual production costs |
|
| Annual cost to purchase cans |
Annual Cost to Purchase Batteries |
| Part 1 Cash Flows Over the Life of the Project |
|
|
|
| Before Tax |
Tax |
After Tax |
|
|
| Item |
Amount |
Effect |
Amount |
|
|
| Annual cash savings |
|
|
| Tax savings due to depreciation |
|
|
| Total after-tax annual cash flow |
| Part 2 Payback Period |
|
|
| years |
| Part 3 Accounting Rate of Return |
|
| Accounting income as result of decreased costs |
|
|
| Annual cash savings |
|
|
| Less depreciation |
|
|
| Before tax income |
|
|
| Tax at Current Rate |
|
|
| After tax income |
|
|
| Accounting Rate of Return |
| Part 4 Net Present Value |
|
|
|
|
| Before Tax |
| After Tax |
PV |
Present |
|
|
| Item |
Year |
Amount |
Tax % |
Amount |
Factor |
Value |
|
|
| Cost of machine |
0 |
|
|
| Annual cash savings |
1-10 |
|
|
| Tax savings due to depreciation |
1-10 |
|
|
| Disposal value |
10 |
|
|
| Net Present Value |
| Part 5 Internal Rate of Return and Modified Internal Rate of Return |
|
|
|
|
|
| After Tax |
|
|
|
| Item |
Year |
Amount |
|
|
|
| Cost of machine |
0 |
|
|
|
| Year 1 inflow |
1 |
|
|
|
| Year 2 inflow |
2 |
|
|
|
| Year 3 inflow |
3 |
|
|
|
| Year 4 inflow |
4 |
|
|
|
| Year 5 inflow |
5 |
|
|
|
| Year 6 7nflow |
6 |
|
|
|
| Year 7 inflow |
7 |
|
|
|
| Year 8 inflow |
8 |
|
|
|
| Year 9 inflow |
9 |
|
|
|
| Year 10 inflow |
10 |
|
|
|
| Internal Rate of Return |
|
|
|
| Modified Internal Rate of Return |
|
|
|
| Net Present Value |
Mocart808
CourseProjectTemplateMay2024.xlsx
