Old MathJax webview

75% JE E- E Assignment 2 co prepare a weekly cash flow table for the first 24 months using Micro functions in Microsoft Excel, that can be used to assist calculation us etermining profitability of any cashflows, such as: (PW) values Net Present Values : NPV(rate, value 1, [Value2], 11 : IRR(values, (guess]) of Return (IRR) Ease explore these functions. port, you must define your company's MARR value and show: arison between current operations with new automated system all possible cash-out (all possible costs, such as material cost, rental, tc.) and cash-in (such as revenues, profit, cost saving, market values, etc.) a - rosoft Excel, evaluate every option, by using Equivalent Worth Method, ar aternal Rate of Return Method. Then comment and make conclusion on profi each option. (You may create multiple options, consist of profitable, and als table option. Learn how the evaluation can be done using Microsoft Excel fc ons.) crosoft Excel, evaluate every option, by using Equivalent Worth Method, an Internal Rate of Return Method. Then comment and make conclusion on profit f each option. (You may create multiple options, consist of profitable, and als fitable option. Learn how the evaluation can be done using Microsoft Excel fo tions.) new tab of the same Microsoft Excel file, evaluate all options, to decide which is the best. Use both methods: Equivalent Worth Method, and by using Incremen lysis Method. Provide conclusion and justification based on all PW and IRR values ent and conclude You are also required to prepare a weekly cash flow table for the first 24 months using Microsoft Excel. Here are some functions in Microsoft Excel, that can be used to assist calculation using various methods in determining profitability of any cashflows, such as: 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. In your cashflow report, you must define your company's MARR value and show; a) Costs comparison between current operations with new automated system b) 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. c) Using Microsoft Excel, evaluate every option, by using Equivalent Worth Method and through Internal Rate of Return Method. Then comment and make conclusion on profit- ability 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.) d) Using Microsoft Excel, evaluate every option, by using Equivalent Worth Method, and through Internal Rate of Return Method. Then comment and make conclusion on profit- ability 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.) e) 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 Incremen- tal Analysis Method. Provide conclusion and justification based on all PW and IRR values. f) Comment and conclude Please assume that wages comply to minimum wage of RM 1,000 per month. Business financing loan (if there is any) is at 4%. Please also check the electricity tariffs with TNB for commercial premises. 75% JE E- E Assignment 2 co prepare a weekly cash flow table for the first 24 months using Micro functions in Microsoft Excel, that can be used to assist calculation us etermining profitability of any cashflows, such as: (PW) values Net Present Values : NPV(rate, value 1, [Value2], 11 : IRR(values, (guess]) of Return (IRR) Ease explore these functions. port, you must define your company's MARR value and show: arison between current operations with new automated system all possible cash-out (all possible costs, such as material cost, rental, tc.) and cash-in (such as revenues, profit, cost saving, market values, etc.) a - rosoft Excel, evaluate every option, by using Equivalent Worth Method, ar aternal Rate of Return Method. Then comment and make conclusion on profi each option. (You may create multiple options, consist of profitable, and als table option. Learn how the evaluation can be done using Microsoft Excel fc ons.) crosoft Excel, evaluate every option, by using Equivalent Worth Method, an Internal Rate of Return Method. Then comment and make conclusion on profit f each option. (You may create multiple options, consist of profitable, and als fitable option. Learn how the evaluation can be done using Microsoft Excel fo tions.) new tab of the same Microsoft Excel file, evaluate all options, to decide which is the best. Use both methods: Equivalent Worth Method, and by using Incremen lysis Method. Provide conclusion and justification based on all PW and IRR values ent and conclude You are also required to prepare a weekly cash flow table for the first 24 months using Microsoft Excel. Here are some functions in Microsoft Excel, that can be used to assist calculation using various methods in determining profitability of any cashflows, such as: 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. In your cashflow report, you must define your company's MARR value and show; a) Costs comparison between current operations with new automated system b) 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. c) Using Microsoft Excel, evaluate every option, by using Equivalent Worth Method and through Internal Rate of Return Method. Then comment and make conclusion on profit- ability 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.) d) Using Microsoft Excel, evaluate every option, by using Equivalent Worth Method, and through Internal Rate of Return Method. Then comment and make conclusion on profit- ability 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.) e) 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 Incremen- tal Analysis Method. Provide conclusion and justification based on all PW and IRR values. f) Comment and conclude Please assume that wages comply to minimum wage of RM 1,000 per month. Business financing loan (if there is any) is at 4%. Please also check the electricity tariffs with TNB for commercial premises