Develop a spreadsheet model and use it to find the project’s NPV, IRR, and payback period. Conduct sensitivity analysis to determine: Accounting and Finance Management Assignment, UM, Malaysia

School

Universiti Malaya (UM)

*We aren't endorsed by this school

Assignment Type

Individual Assignment

Subject

Accounting and Finance

Uploaded by Malaysia Assignment Help

Date

04/03/2023

Develop a spreadsheet model and use it to find the project’s NPV, IRR, and payback period.
Conduct sensitivity analysis to determine the sensitivity of NPV to changes in the sales price, variable costs per unit, and the number of units sold. Set these variables’ values at 10% and 20% above and below their base-case values. Include a graph in your analysis.
Conduct a scenario analysis. Assume that there is a 30% probability that best-case conditions, with the sales price, number of units sold, variable costs per unit, and fixed cost are 20% better than its base-case value. There is a 30% probability of worse-case conditions, with the variable 20% worse than the base value. The base-case condition is assumed to have a 40% probability. What would be the project’s coefficient of variation NPV?
If the project appears to be more or less risky than an average project, find its risk-adjusted NPV, IRR, and payback.
On the basis of the information in the problem, would you recommend that the project be accepted?

Stuck in This Assignment? Deadlines Are Near?

Hire Assignment Helper Now!

Get Help By Expert

Looking for reliable and top-quality final year project help in Malaysia? Look no further than Malaysiaassignmenthelp.com! Our team of experienced and skilled writers and researchers are here to provide you with the best possible support for your final year project. Whether you need help with choosing a topic, conducting research, or writing and editing your paper, we have got you covered. Our assignment help services are affordable, reliable, and tailored to meet your specific needs. So why wait? Contact us today and take the first step towards academic success!

Answer