I need the attached Cost Accounting task to be done within 1-2 hr

profilestudentof567
TemplateToWorkOn.xlsx
Home>Business & Finance homework help>Accounting homework help>I need the attached Cost Accounting task to be done within 1-2 hr

ELON MOTORS

ACCT434/436
Course Project
Elon Motors
Project Template
Elon Motors
Data:
Cost of new equipment
Expected life of equipment in years
Salvage Value
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 direct material for of 2,500 Batteries
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