Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Proforma Income Statement and Capital Budgeting ( no additional details is given ) Huffman Systems has forecasted the following sales for home alarm systems to

Proforma Income Statement and Capital Budgeting (no additional details is given)
Huffman Systems has forecasted the following sales for home alarm systems to be 63,000 units in Year 1.
- Sales volume is to increase by 10% year on year, and decreases by 5% in the final 2 years.
- The cost per unit is RM40 per unit and is estimated to increase by 4% year on year.
- The cost of goods sold is 35% of the selling price.
- The fixed cost per year is RM500,000.
- The company's interest expenses per year is RM75,000
- To produce the new product, the company spend RM800,000 on manufacturing equipment, with additional RM50,000 on installation of the equipment.
- The equipment is to be depreciated based on MACRS, 7-year schedule, and will be sold at the end of Year 7 for 15% of the purchase price.
- The project cost is RM1.2 million, with additional working capital requirement of 10% of the project cost.
- The cost of capital is 7.12%, and the tax rate is 24%.
1. Total asset cost to be depreciated is RM____________.
2. Depreciation expenses in Year 3 is RM__________.
3. Accumulated Depreciation in Year 5 is RM__________.
4. Book Value in Year 6 is RM__________.
5. The disposal price is RM___________.
6. The Gain/ Loss on Disposal is RM___________.
7. The After tax cash flow/ tax shield from the disposal of the asset is RM__________.
8. The sales volume in Year 5 is _________ units.
9. The sales volume in Year 7 is _________ units.
10. Sales Revenues in Year 2 is RM_____________.
11. Sales Revenues in Year 4 is RM_____________.
12. The EBIT in Year 3 is RM__________.
13. The EBT in Year 6 is RM________________.
14. The OCF in Year 7 is RM_______________.
15. The initial outlay of the project is RM_____________.
16. The terminal value of the project is RM_____________.
17. Total Present Value of the project is RM_____________.
18. Total Future Value of the project is RM_____________.
19. Payback Period is ___________.
20. Discounted Payback Period is ___________.
21. NPV is RM_____________.
22. PI is RM_____________.
23. IRR is ________%.
24. MIRR is ________%.
25. EAA of the project is RM____________.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

AQA AS Accounting Unit 1 Introduction To Financial Accounting

Authors: Brendan Casey

1st Edition

1499789653, 978-1499789652

More Books

Students also viewed these Finance questions

Question

1. Study/review the moves of a focus/mini lesson.

Answered: 1 week ago