Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
i need help with this problem but can i ask to show the formulas for each part of the question through excel so i can
i need help with this problem but can i ask to show the formulas for each part of the question through excel so i can understand and kearn better thank you
Format Punter Morge & Center - $ % 893 Conditional Format Formatting Table Style Styles Font Alignment Numbe 19 fr B D E 1 ENGR 3315 Excel Lab #3 2 31 4 Consider the following alternatives: 5 300,000 10,000 10,000 560,000 7 b Project A Project B Project 7 First Cost 100,000 200,000 8 MRO 15,000 25,000 9 Annual Benefit 30,000 40,000 10 Salvage Value 100,000 270,000 11 Life, years 5 5 12 13 When each project reaches end of life, it will be sold for its salvage 14 value and there will be no replacement. 15 11 Using the Spreadsheets and Graphs tabs below complete the following items! 17 (al Prepare a spreadsheet of EUAW as a function of interest 18 rate for each individual project and for the relevent Incrementals. (20 points) 19 20 (b) Prepare a cash flow table for each alternative and for the relevent incrementals. [20 Points) 25 22 (c) Calculate Individual RORs and incremental IRRS. (20 points) 03 24 (d) Graph EUAW as a function of interest rate for each project: 25 save on a separate sheet and label all titles and all relevent IRRs and RORs, 120 Points) 26 27 le) Construct a choice table to present the information in compact and easily understandable form. (10 Points) 28 29 (f Which project is preferred at MARR = 10,00%? (10 Points) 29 31 (100 Points Possible 32 10 Problem Spreadsheets Graph Sendy Type here to search O E R T T s Incut Calih 2 Lo recopy General . AutoSum - 47 12 AA== A 4 Puste Wrap Text Morge Il Conter- - Format Painter ipboard BIU. Intot Delato Format $ -% -48 Conditional Formatas Cell Formatting Table Styles Sorts Find & Filter Select Font Alignment Number St Cel Editing Ideas HBO f N P H H 1 M (b) Prepare a cash flow table for each alternative and for the relevent increments. Year B B-A C-B 0 1 2 3 4 5 6 7 (c) Calculate Individual RORs and incremental IRRs. ROR/IRR 9 B D E F 1 (a) Prepare a spreadsheet of EUAW as a function of interest 2 rate for each individual project and for the relevent incrementals. 3 4 Interest EUAWA EUAWB EUAWC EUAW B-A EUAW G-B 5 0 6 1 7 2 8 9 4 10 5 5 6 12 7 13 8 14 15 10 16 12 17 15 18 18 19 20 20 25 21 30 22 35 23 40 24 45 25 50 26 27 28 29 30 31 32 Problem Spreadsheets Graph Heade Type here to search O e (d) Construct graph on sepearate worksheet. Use tab next to Spreadsheets labeled Graph. (e) Construct a choice table. (f) At MARR = 10.00%, the preferred project is: 5:42 PM 11/5/2020 Calibri C AutoSum Pesto copy 1 Format Painter - 12 AA wino Tint A Beige Corte BLU- 5 % Condition Parall Formatting Styles Insert Dolote Format Clear Clipboard Tort B41 B c D F H 1 1 M N 2 (d) Construct graph on this worksheet 3 3 4 5 6 7 8 9 10 11 12 13 15 16 18 19 20 22 23 24 25 26 27 25 29 BE 31 32 33 Type here to search Format Punter Morge & Center - $ % 893 Conditional Format Formatting Table Style Styles Font Alignment Numbe 19 fr B D E 1 ENGR 3315 Excel Lab #3 2 31 4 Consider the following alternatives: 5 300,000 10,000 10,000 560,000 7 b Project A Project B Project 7 First Cost 100,000 200,000 8 MRO 15,000 25,000 9 Annual Benefit 30,000 40,000 10 Salvage Value 100,000 270,000 11 Life, years 5 5 12 13 When each project reaches end of life, it will be sold for its salvage 14 value and there will be no replacement. 15 11 Using the Spreadsheets and Graphs tabs below complete the following items! 17 (al Prepare a spreadsheet of EUAW as a function of interest 18 rate for each individual project and for the relevent Incrementals. (20 points) 19 20 (b) Prepare a cash flow table for each alternative and for the relevent incrementals. [20 Points) 25 22 (c) Calculate Individual RORs and incremental IRRS. (20 points) 03 24 (d) Graph EUAW as a function of interest rate for each project: 25 save on a separate sheet and label all titles and all relevent IRRs and RORs, 120 Points) 26 27 le) Construct a choice table to present the information in compact and easily understandable form. (10 Points) 28 29 (f Which project is preferred at MARR = 10,00%? (10 Points) 29 31 (100 Points Possible 32 10 Problem Spreadsheets Graph Sendy Type here to search O E R T T s Incut Calih 2 Lo recopy General . AutoSum - 47 12 AA== A 4 Puste Wrap Text Morge Il Conter- - Format Painter ipboard BIU. Intot Delato Format $ -% -48 Conditional Formatas Cell Formatting Table Styles Sorts Find & Filter Select Font Alignment Number St Cel Editing Ideas HBO f N P H H 1 M (b) Prepare a cash flow table for each alternative and for the relevent increments. Year B B-A C-B 0 1 2 3 4 5 6 7 (c) Calculate Individual RORs and incremental IRRs. ROR/IRR 9 B D E F 1 (a) Prepare a spreadsheet of EUAW as a function of interest 2 rate for each individual project and for the relevent incrementals. 3 4 Interest EUAWA EUAWB EUAWC EUAW B-A EUAW G-B 5 0 6 1 7 2 8 9 4 10 5 5 6 12 7 13 8 14 15 10 16 12 17 15 18 18 19 20 20 25 21 30 22 35 23 40 24 45 25 50 26 27 28 29 30 31 32 Problem Spreadsheets Graph Heade Type here to search O e (d) Construct graph on sepearate worksheet. Use tab next to Spreadsheets labeled Graph. (e) Construct a choice table. (f) At MARR = 10.00%, the preferred project is: 5:42 PM 11/5/2020 Calibri C AutoSum Pesto copy 1 Format Painter - 12 AA wino Tint A Beige Corte BLU- 5 % Condition Parall Formatting Styles Insert Dolote Format Clear Clipboard Tort B41 B c D F H 1 1 M N 2 (d) Construct graph on this worksheet 3 3 4 5 6 7 8 9 10 11 12 13 15 16 18 19 20 22 23 24 25 26 27 25 29 BE 31 32 33 Type here to searchStep 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