if possible say what formulas to use in excel

wala Review View Tell me Garamond 12 AA Py Wrap Text General BTW THIDO Merge & Center $ - % C D H 1 Pe Th Project 1: A company that manufactures bicycles has an opportunity to begin maufacturing a new higher end model, which has additional features from the models they currently make. These features would require some new equipment to be purchaed Because of the risk level involved in taking on a new product, management is trying to determine whether the returns will justify the risk. The individuals within the sopher of management that are evaluating the project, have determined 15% discountate in appropriate for evaluation purposes. Management has asked you to prepare an anlaysis of the project the following information and anumeon 1) The new equipment will have a cost of $358,000, avage value of 510,000 and a 10-year useful life. Straight line depreciation will be used 2) The projected revenues, costs, and results for each of the 10 years of this project are as follows $315.000 Sales Len Manufacturing Costs Depreciation Shipping costs Administrative costs Income before income Income tax expe Net income 5190,000 140.00 17.000 15.000 Instruc 256 800 5200 22 $34,920 Instructions: ting the template below a) compute the annual rate of return. b) compute the payback period Lost Pject Template 15 - NA MacBook Pro ! # $ 1 2 3 4 % 5 6 7 8 Garamond 12 * 2Wrap Test General III lili BIU - A HI 1941 Merge & Center $ % Cand Forma M Income tax expense Net income $34,920 Instructions: Using the template below a) compute the annual rate of return b) compare the payback period c) compute the NPV using the determined 15% discount rate to rpaar' aplai iraar aathi d) compute the NPV using a 12% din contrates that Management has a comparison for analysis a) In order to get full points for this project Cells in red require input of TEXT OR VALUES Celles in green on the template should be a FORMULA b) Compute the annual rate of return Average net income Average investment Annual rate of return Average Net Income Add depreciation Annual rate of return $4,020 94. 100.54 2 b) Compute the payluck period. Note that you will need to arrive at the net annual cash flow FIRST Net Income Deprecation Annual cash flow $14,020 1 69,720 Net income Depreciation Annual net cash flow Excel Template 15 SA MacBook Pro EBBABAIRT Window Help Excel Project 3 - Template cel Toit View at Format Tools Auarae ABESU Insert Draw Page Layout Formulas Data Garamond AA AA Review View Tell me General $% Marge Center Canon Format Call Formatting as Table Styles L M Computed that you will need to the neamulcah PRST Net Income De Compute the back SCO Net income Depreciation Annualne des met Al net cash Anment flows Paxhack period in an Camp NPV using the core of 13 and the scend You in the widely d) Om the NPV in out in the pro 0.13 of HATI NPER PUT PV PV 0.15 RATE NPER PMT FV PV 15 ditv MacBook Pro 1 2 # 3 $ 4. % 5 & 7 6 8 C 9 1A 1 Excel Fia Edit Format Tools Data Window View BEZ Excel Project 3 - Template 2 Insert Draw Page Layout Formulas Data Review View Tell me Garamond 12 AA Wrap Test General BV Marge & Center $ - % ) . Conditional Formu Cal Formatting Table Style x D M N Promos Com Land RN the d) Camp NIVg the count of the PVPd formula where required You had it out your in the provided 0.12 KATI NPER PME FV KATI NER PS FV 15 MacBook Pro & 2 # 3 $ 4 % 5 6 7 8 9 Q W E E R T Y U Excel EG View Insert Format Tools Data Window Help DO Excel Project 3 - Template Home insert Draw Page Layout Formulas Data Review View Tell me Garamond P. 9 wrap Tout General Pet BTU- Merge Center $% Conditional Formatting 057 M A You shout your in the peovided space Pemotos linflow 883835 RAT NPER PMT PV 0.12 RATE NPEX PMT FY PV 97 Printah ow 100 101 102 1101 104 105 108 107 100 101 110 111 112 Net persent value w the popularment en tot mot Huguel Year Na Ready 15 E A MacBook Pro Data Tools Edit Window Help Excel Project 3 - Template View Insert Format ABE. Page Layout Formulas Data Review View Tell me 18 Wrest General Delete amond 12 A A SA EE Merge Center $% 9 Conditional Forwal Call Formatting Table Styles Q M The une de company has another party pened to expand the current plant to in production and whimsy be where we are with their expandet manfacturing capacity. The company has determined the folowe informacions for the 15 1) The memes for the project to the com 500.000 Depreciation we caleras year with no vale 2) The procedame for each of the five years are solo Year 2 Year Year Year 61,200 22.00 Instre hry the tuinplaner .) come the of b) latest amalur as his ) come packed ) cowe NPV the end 1 Samuel compare the remain for the shacht is more Avenge net Avant 15 tv MacBook Pro X TEA $ & Tools Data Window Help View Intert Format ABU. Excel Project 3 - Template Page Layout w Formulas Data Review View Tell me mond 12 SEE wrap Test General $% % int Date Formal Merge Center Conditional Format Cal Forming as Tale Styles U W N Avere not income Arvestment Ama ofrer 1) Preparate low and love me cash flow. Dort for show deprecated SMD Problem NA Caulains Nel Culo Calw of . Compare the periode. Mi Dia al til fleres Capital investment Cumulative how your Remaining to be recovered Netchtow, year 4 Pahack period, Total hypered in you .. dtv MacBook Pro GON Wrap Text SE 12 id Conditional Fe Formatting as Merge & Center $ - % U M d) 0 Q Compute the NPVUng the discount rate of 15% and the NPV Excel formula. You should list out your inputs in the provided spaces Thesent value of cash inflowe RATE Year 1 Year 2 Year) Year 4 Years Present of cash out Net present value 1stpmporal optables the disas rute Respond Yer or Na Comparte from Project 2 dhove to those of Project 1 by making an "X" in the box of the Project that is more appealing for each item below None for the NPV companies, we the results from Project 1 uning the 19% discount rate, lettere Aman of Net Present Valor P 12 Xolbet aption for penet 15 MacBook Pro @ A 2 # 3 $ 4 & % 5 C 6 7 8 9 wala Review View Tell me Garamond 12 AA Py Wrap Text General BTW THIDO Merge & Center $ - % C D H 1 Pe Th Project 1: A company that manufactures bicycles has an opportunity to begin maufacturing a new higher end model, which has additional features from the models they currently make. These features would require some new equipment to be purchaed Because of the risk level involved in taking on a new product, management is trying to determine whether the returns will justify the risk. The individuals within the sopher of management that are evaluating the project, have determined 15% discountate in appropriate for evaluation purposes. Management has asked you to prepare an anlaysis of the project the following information and anumeon 1) The new equipment will have a cost of $358,000, avage value of 510,000 and a 10-year useful life. Straight line depreciation will be used 2) The projected revenues, costs, and results for each of the 10 years of this project are as follows $315.000 Sales Len Manufacturing Costs Depreciation Shipping costs Administrative costs Income before income Income tax expe Net income 5190,000 140.00 17.000 15.000 Instruc 256 800 5200 22 $34,920 Instructions: ting the template below a) compute the annual rate of return. b) compute the payback period Lost Pject Template 15 - NA MacBook Pro ! # $ 1 2 3 4 % 5 6 7 8 Garamond 12 * 2Wrap Test General III lili BIU - A HI 1941 Merge & Center $ % Cand Forma M Income tax expense Net income $34,920 Instructions: Using the template below a) compute the annual rate of return b) compare the payback period c) compute the NPV using the determined 15% discount rate to rpaar' aplai iraar aathi d) compute the NPV using a 12% din contrates that Management has a comparison for analysis a) In order to get full points for this project Cells in red require input of TEXT OR VALUES Celles in green on the template should be a FORMULA b) Compute the annual rate of return Average net income Average investment Annual rate of return Average Net Income Add depreciation Annual rate of return $4,020 94. 100.54 2 b) Compute the payluck period. Note that you will need to arrive at the net annual cash flow FIRST Net Income Deprecation Annual cash flow $14,020 1 69,720 Net income Depreciation Annual net cash flow Excel Template 15 SA MacBook Pro EBBABAIRT Window Help Excel Project 3 - Template cel Toit View at Format Tools Auarae ABESU Insert Draw Page Layout Formulas Data Garamond AA AA Review View Tell me General $% Marge Center Canon Format Call Formatting as Table Styles L M Computed that you will need to the neamulcah PRST Net Income De Compute the back SCO Net income Depreciation Annualne des met Al net cash Anment flows Paxhack period in an Camp NPV using the core of 13 and the scend You in the widely d) Om the NPV in out in the pro 0.13 of HATI NPER PUT PV PV 0.15 RATE NPER PMT FV PV 15 ditv MacBook Pro 1 2 # 3 $ 4. % 5 & 7 6 8 C 9 1A 1 Excel Fia Edit Format Tools Data Window View BEZ Excel Project 3 - Template 2 Insert Draw Page Layout Formulas Data Review View Tell me Garamond 12 AA Wrap Test General BV Marge & Center $ - % ) . Conditional Formu Cal Formatting Table Style x D M N Promos Com Land RN the d) Camp NIVg the count of the PVPd formula where required You had it out your in the provided 0.12 KATI NPER PME FV KATI NER PS FV 15 MacBook Pro & 2 # 3 $ 4 % 5 6 7 8 9 Q W E E R T Y U Excel EG View Insert Format Tools Data Window Help DO Excel Project 3 - Template Home insert Draw Page Layout Formulas Data Review View Tell me Garamond P. 9 wrap Tout General Pet BTU- Merge Center $% Conditional Formatting 057 M A You shout your in the peovided space Pemotos linflow 883835 RAT NPER PMT PV 0.12 RATE NPEX PMT FY PV 97 Printah ow 100 101 102 1101 104 105 108 107 100 101 110 111 112 Net persent value w the popularment en tot mot Huguel Year Na Ready 15 E A MacBook Pro Data Tools Edit Window Help Excel Project 3 - Template View Insert Format ABE. Page Layout Formulas Data Review View Tell me 18 Wrest General Delete amond 12 A A SA EE Merge Center $% 9 Conditional Forwal Call Formatting Table Styles Q M The une de company has another party pened to expand the current plant to in production and whimsy be where we are with their expandet manfacturing capacity. The company has determined the folowe informacions for the 15 1) The memes for the project to the com 500.000 Depreciation we caleras year with no vale 2) The procedame for each of the five years are solo Year 2 Year Year Year 61,200 22.00 Instre hry the tuinplaner .) come the of b) latest amalur as his ) come packed ) cowe NPV the end 1 Samuel compare the remain for the shacht is more Avenge net Avant 15 tv MacBook Pro X TEA $ & Tools Data Window Help View Intert Format ABU. Excel Project 3 - Template Page Layout w Formulas Data Review View Tell me mond 12 SEE wrap Test General $% % int Date Formal Merge Center Conditional Format Cal Forming as Tale Styles U W N Avere not income Arvestment Ama ofrer 1) Preparate low and love me cash flow. Dort for show deprecated SMD Problem NA Caulains Nel Culo Calw of . Compare the periode. Mi Dia al til fleres Capital investment Cumulative how your Remaining to be recovered Netchtow, year 4 Pahack period, Total hypered in you .. dtv MacBook Pro GON Wrap Text SE 12 id Conditional Fe Formatting as Merge & Center $ - % U M d) 0 Q Compute the NPVUng the discount rate of 15% and the NPV Excel formula. You should list out your inputs in the provided spaces Thesent value of cash inflowe RATE Year 1 Year 2 Year) Year 4 Years Present of cash out Net present value 1stpmporal optables the disas rute Respond Yer or Na Comparte from Project 2 dhove to those of Project 1 by making an "X" in the box of the Project that is more appealing for each item below None for the NPV companies, we the results from Project 1 uning the 19% discount rate, lettere Aman of Net Present Valor P 12 Xolbet aption for penet 15 MacBook Pro @ A 2 # 3 $ 4 & % 5 C 6 7 8 9