Develop a spreadsheet model and use it to find the project

Assignment Help Managerial Accounting

Reference no: EM133392206

Question: JD Sdn Bhd has developed a new industrial detergent that can be used in motor vehicle garages. It would cost RM1 million to buy the equipment necessary to manufacture the blenders, and initially it would require net operating working capital equal to 10% of the 1st year sales. The project would have a life of 5 years. If the project is undertaken, it must be continued for the entire 5 years. The firm believes it could sell 50,000 units per year. The detergents would sell for RM15 per unit. After the first year, JD intends to increase the sales price by 3% annually. The variable cost is RM5 per unit. will also increase at the inflation rate of 3%.The company's fixed costs would be RM250,000 at Year 1 and would also increase at a rate of 3% annually. The equipment would be depreciated over a 5-year period, using the straight-line method. The annual depreciation will be calculated based on a salvage value of the equipment at the end of the project's 5-year life of RM100,000. The company however estimated the machine can be sold as scrap for RM250,000. The corporate tax rate is 25%. The cost of capital is 10%.
a. Develop a spreadsheet model and use it to find the project's NPV, IRR, and payback

Reference no: EM133392206

Questions Cloud

Encourage participation by the community in the area : How would you establish the first meeting? What would you do to encourage participation by the community in the area?

Discusses the balanced scorecard and strategy map : Discusses the balanced scorecard and strategy map. Discuss all of the following: Any experience you have with utilizing the balanced scorecard and strategy map

Prison eras from the united states prison history : Pick one of the 10 prison eras from the United States prison history. Utilizing research describe the major pros and cons of the ERA that you picked.

Explain how depreciation provides a tax reduction benefit : Explain how depreciation provides a tax reduction benefit that increases cash flow.

Develop a spreadsheet model and use it to find the project : Develop a spreadsheet model and use it to find the project's NPV, IRR, and payback - The company however estimated the machine can be sold as scrap

Determining the exact liability of the other ten : the factors which may be important in determining the exact liability (if any) of the other ten lawyers

Would the company incur? how would these costs be considered : Using the NIKE company, what specific types of SG&A costs would the company incur? How would these costs be considered in product costing? Can you please

Organizations obligations with respect to its remittance : Northwest Territories and Nunavut Payroll Tax to help ensure they are aware of this tax and the organization's obligations with respect to its remittance

What is the definition of investigation : What is the definition of an investigation? What are the major goals of a criminal investigation? When should the investigator start taking notes?

User Account

All Pages