Question: Present Worth (PW) values = Net Present Values : NPV(rate, value 1, [Value2...) Internal Rate of Return (IRR) IRR(values, (guess]) and many more. Please explore

 Present Worth (PW) values = Net Present Values : NPV(rate, value

Present Worth (PW) values = Net Present Values : NPV(rate, value 1, [Value2...) Internal Rate of Return (IRR) IRR(values, (guess]) and many more. Please explore these functions. For this assignment, student will create cashflows of project/product/event/etc., to be evaluated. The assignment will cover the following points: 1) Select and describe your project/product/event/etc. in detail. What are you going to purpose? Define more than 3 options. Also define your company's MARR. 2) List down all possible cash-out (all possible costs, such as material cost, rental, shipping, etc.) and cash-in (such as revenues, profit, cost saving market values, etc.) of all options. 3) Using Microsoft Excel, evaluate every option, by using Equivalent Worth Method, and through Internal Rate of Return Method. Then comment and make conclusion on profitability of each option. (You may create multiple options, consist of profitable, and also non-profitable option. Learn how the evaluation can be done using Microsoft Excel for both options.) 4) Then on new tab of the same Microsoft Excel file, evaluate all options, to decide which option is the best. Use both methods: Equivalent Worth Method, and by using Incremental Analysis Method. Provide conclusion and justification based on all PW and IRR values

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

\f