Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
need help! Can you please show excel fuctions. THANKYOU SO MUCH! Vulness.com developed a new server that will be used for comme 10 million at
need help! Can you please show excel fuctions. THANKYOU SO MUCH!
Vulness.com developed a new server that will be used for comme 10 million at Year to buy the winnecessary to mana there. There working capital of the beginning of each year in the years for * 10 The firm believes it could sell,000 units per year. The wavene would allo$24.00 per tandem !! that variables wordt amount to $15.000 per or Yeart the sale price and 12 tone of the company's variable would be on Year ration 15 The ver project would have the ot years. The project is undertaken it must be continued tre 10 The gent would be depreciated over a year and using MACRS The state market value 17 at the end of the property is 100.000 10 Webmaster derailussa tasais 28. the cost of capital 10 free das with a coefficient of variation of NPV been and 12. Lowoch are evaluated with a WCCB. rik projecte Ane, the project returns are expected to be highly correlated with on the former PLATER TURA 0.4 10 2.23 12.12 24000 118.ST 2140 . Develop spreadsheet model and use it to find the project and peace 28 Input Duta in onda olan 27 28 30 29 Eppendo 30 Noteparing working capitales Reyes 31 32 Bespres per 14.00 2105 39 arte con el SED Paytek 110 34 Norte de 100 TCI Indoned SON Estimated salvester 1500 17 Depression years Year Yes 29 Deprec 20. 10:20 30 Tart 40 WACC traverser les 10 41 42 intermediate alle . 43 Units sold 1.800 1. 44 Sales price per united 524.00 1247 45 Variable cost per un fel depe 117.30 $18.03 40 Navaratie colder 24720 47 Sales were 4 Required levelet operating working capital 40 Basis for depreciation 50 Annual equipment dept. 20.00 51 Annual depreciation expense 52 Ending lik Val Cost - Accu Despre 53 Savage value Proton) on salvage Tax on profit for loss) Netcashow due to salvage se Cash Flow Forecast 59 Sales revenue 60 Variable costs 61 Norwariable operating costs 62 Depreciation equipment) 63 Oper. Income before taxes (EBIT) 64 Taxes on operating income 60% 65 Net operating profit after taxes 66 Add back depreciation 67 Equipment purchases 88 Cash flow due to change in NOWC 69 Net cash flow due to salvage 70 Net Cash Flow (Time line of cash flowa) 71 72 Key Results: Appraisal of the Proposed Project 73 74 Net Present Value at 10%) 75 ERR 76 MIRR 77 Payback 78 Discounted Payback - 79 Data for Payback Years 80 81 Net cash flow 82 Cumulative CF Part of year required for payback Year Years Data for Discounted Payback Years Years 2 1 88%89889 Net cash flow Discounted cash flow Cumulative CF Part of year required for discounted payback Vulness.com developed a new server that will be used for comme 10 million at Year to buy the winnecessary to mana there. There working capital of the beginning of each year in the years for * 10 The firm believes it could sell,000 units per year. The wavene would allo$24.00 per tandem !! that variables wordt amount to $15.000 per or Yeart the sale price and 12 tone of the company's variable would be on Year ration 15 The ver project would have the ot years. The project is undertaken it must be continued tre 10 The gent would be depreciated over a year and using MACRS The state market value 17 at the end of the property is 100.000 10 Webmaster derailussa tasais 28. the cost of capital 10 free das with a coefficient of variation of NPV been and 12. Lowoch are evaluated with a WCCB. rik projecte Ane, the project returns are expected to be highly correlated with on the former PLATER TURA 0.4 10 2.23 12.12 24000 118.ST 2140 . Develop spreadsheet model and use it to find the project and peace 28 Input Duta in onda olan 27 28 30 29 Eppendo 30 Noteparing working capitales Reyes 31 32 Bespres per 14.00 2105 39 arte con el SED Paytek 110 34 Norte de 100 TCI Indoned SON Estimated salvester 1500 17 Depression years Year Yes 29 Deprec 20. 10:20 30 Tart 40 WACC traverser les 10 41 42 intermediate alle . 43 Units sold 1.800 1. 44 Sales price per united 524.00 1247 45 Variable cost per un fel depe 117.30 $18.03 40 Navaratie colder 24720 47 Sales were 4 Required levelet operating working capital 40 Basis for depreciation 50 Annual equipment dept. 20.00 51 Annual depreciation expense 52 Ending lik Val Cost - Accu Despre 53 Savage value Proton) on salvage Tax on profit for loss) Netcashow due to salvage se Cash Flow Forecast 59 Sales revenue 60 Variable costs 61 Norwariable operating costs 62 Depreciation equipment) 63 Oper. Income before taxes (EBIT) 64 Taxes on operating income 60% 65 Net operating profit after taxes 66 Add back depreciation 67 Equipment purchases 88 Cash flow due to change in NOWC 69 Net cash flow due to salvage 70 Net Cash Flow (Time line of cash flowa) 71 72 Key Results: Appraisal of the Proposed Project 73 74 Net Present Value at 10%) 75 ERR 76 MIRR 77 Payback 78 Discounted Payback - 79 Data for Payback Years 80 81 Net cash flow 82 Cumulative CF Part of year required for payback Year Years Data for Discounted Payback Years Years 2 1 88%89889 Net cash flow Discounted cash flow Cumulative CF Part of year required for discounted payback
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669e14394862e_896669e1438c98f9.jpg)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started