Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please can some help me should the excel i provided to run a scenario manager analysis please. i just need someone to use the excel

image text in transcribed

image text in transcribed

image text in transcribed

please can some help me should the excel i provided to run a scenario manager analysis please.

i just need someone to use the excel i provided to create scenario manager. there's no additional information, just using the excel to create scenario.

AL Year 3 0.02 $10,500 $10,000 $43,000 $14,000 Year 3 R N Year 3 $81,490 1 YOUR UNCLE'S EARLY RETIRIEMENT DECISION Year 1 Year 0 Year 2 2 Constants NA 0.03 0.03 3 Salary increase factor NA 4 Part-time wages expected (retired) $10,000 $10,200 NA 5 Buyout amount $15,000 $30,000 NA 6 Cost of living (not retired) $41,000 $42,000 NA $12,000 $13,000 7 Country club dues 9 Inputs Year o Year 1 Year 2 10 Retired (R) or Working [W] NA w w 11 Stay in club? [Y] or [N] NA N N 12 13 Summary of Key Results Year 0 Year 1 Year 2 14 End-of-year cash on hand NA $58,980 $88,990 15 16 Calculations Year 0 Year 1 Year 2 17 Tax rate NA 0 30 0.30 18 Cost of living NA $41000 $42.000 19 Yearly salary or part-time wages $80,000 $82 400 $84,872 20 Country club dues paid NA SO $0 21 Income Statement and 22 Cash Flow Statement Year 0 Year 1 Year 2 23 Beginning of-year cash on hand NA $30,000 $58,980 24 25 Salary or wages NA $82.400 $84.872 26 Buyout income NA $0 27 Total cash into $0 NA CA2 400 Sheet1 94 R72 Year 3 0.15 $28,000 $10.500 $0 Year 3 $88 990 $10,500 $10,000 B Year 0 NA NA $80,000 NA Year 1 Year 2 Year 3 0.30 0.30 0.15 $41,000 $42,000 $28,000 $82,400 $84,872 $10,500 $0 $0 $0 Year 0 Year 1 Year 3 Year 2 NA $30,000 $58,980 $88,990 15 16 Calculations 17 Tax rate 18 Cost of living 19 Yearly salary or part-time wages 20 Country club dues paid 21 Income Statement and 22 Cash Flow Statement 23 Beginning-of-year cash on hand 24 25 Salary or wages 26 Buyout income 27 Total cash inflow 28 Country club dues paid 29 Cost of living 30 Total costs 31 Income before taxes 32 Income tax expense 33 Net income after taxes 34 35 End-of-year cash on hand 36 37 NA NA NA NA NA NA NA NA NA $82,400 $84,872 $10,500 $0 $0 $10,000 $82,400 $84,872 $20,500 $0 $0 $0 $41,000 $42,000 $28,000 $41,000 $42,000 $28,000 $41,400 $42,872 ($7,500) $12,420 $12,862 $0 $28.980 $30,010 ($7,500) $30,000 $58,980 $88,990 $81,490 50 . . . Scenario Manager Analysis Setup Senario Manager and create a Scenario Summary sheet. Your uncle wants to look at the following four possibilities Retire now, staying in the club ("Loaf-In) Retire now, leaving the club ("Loaf-Out"). Work three more years that is, do not take any huyout bonuses), staying in the club (Delay-In"). Work three more years, leaving the club "Delny-Out"). You should enter the noncontiguous input cell ranges as follows: CIO:E10, C11 The only output oel should be the Year 3 End-of-year cash on hand cell in the Summary of Key Results section Your uncle will choose the option that yields the highest Year 3 End-of-year cash on hand. You ut your Sonario Summary sheet to see which strategy yields the highest amount To check your work, you should attain the values shown in Figure C-26. You should format the same sheet appropriately, for example, see Figure C-26 . D Scenario Summary ed or Working Tear 118 Hetidor Word Teal w Y 1 197.1 511949 FIGURE C-26 Scenario Summary AL Year 3 0.02 $10,500 $10,000 $43,000 $14,000 Year 3 R N Year 3 $81,490 1 YOUR UNCLE'S EARLY RETIRIEMENT DECISION Year 1 Year 0 Year 2 2 Constants NA 0.03 0.03 3 Salary increase factor NA 4 Part-time wages expected (retired) $10,000 $10,200 NA 5 Buyout amount $15,000 $30,000 NA 6 Cost of living (not retired) $41,000 $42,000 NA $12,000 $13,000 7 Country club dues 9 Inputs Year o Year 1 Year 2 10 Retired (R) or Working [W] NA w w 11 Stay in club? [Y] or [N] NA N N 12 13 Summary of Key Results Year 0 Year 1 Year 2 14 End-of-year cash on hand NA $58,980 $88,990 15 16 Calculations Year 0 Year 1 Year 2 17 Tax rate NA 0 30 0.30 18 Cost of living NA $41000 $42.000 19 Yearly salary or part-time wages $80,000 $82 400 $84,872 20 Country club dues paid NA SO $0 21 Income Statement and 22 Cash Flow Statement Year 0 Year 1 Year 2 23 Beginning of-year cash on hand NA $30,000 $58,980 24 25 Salary or wages NA $82.400 $84.872 26 Buyout income NA $0 27 Total cash into $0 NA CA2 400 Sheet1 94 R72 Year 3 0.15 $28,000 $10.500 $0 Year 3 $88 990 $10,500 $10,000 B Year 0 NA NA $80,000 NA Year 1 Year 2 Year 3 0.30 0.30 0.15 $41,000 $42,000 $28,000 $82,400 $84,872 $10,500 $0 $0 $0 Year 0 Year 1 Year 3 Year 2 NA $30,000 $58,980 $88,990 15 16 Calculations 17 Tax rate 18 Cost of living 19 Yearly salary or part-time wages 20 Country club dues paid 21 Income Statement and 22 Cash Flow Statement 23 Beginning-of-year cash on hand 24 25 Salary or wages 26 Buyout income 27 Total cash inflow 28 Country club dues paid 29 Cost of living 30 Total costs 31 Income before taxes 32 Income tax expense 33 Net income after taxes 34 35 End-of-year cash on hand 36 37 NA NA NA NA NA NA NA NA NA $82,400 $84,872 $10,500 $0 $0 $10,000 $82,400 $84,872 $20,500 $0 $0 $0 $41,000 $42,000 $28,000 $41,000 $42,000 $28,000 $41,400 $42,872 ($7,500) $12,420 $12,862 $0 $28.980 $30,010 ($7,500) $30,000 $58,980 $88,990 $81,490 50 . . . Scenario Manager Analysis Setup Senario Manager and create a Scenario Summary sheet. Your uncle wants to look at the following four possibilities Retire now, staying in the club ("Loaf-In) Retire now, leaving the club ("Loaf-Out"). Work three more years that is, do not take any huyout bonuses), staying in the club (Delay-In"). Work three more years, leaving the club "Delny-Out"). You should enter the noncontiguous input cell ranges as follows: CIO:E10, C11 The only output oel should be the Year 3 End-of-year cash on hand cell in the Summary of Key Results section Your uncle will choose the option that yields the highest Year 3 End-of-year cash on hand. You ut your Sonario Summary sheet to see which strategy yields the highest amount To check your work, you should attain the values shown in Figure C-26. You should format the same sheet appropriately, for example, see Figure C-26 . D Scenario Summary ed or Working Tear 118 Hetidor Word Teal w Y 1 197.1 511949 FIGURE C-26 Scenario Summary

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Applications In Energy Finance

Authors: Christos Floros, Ioannis Chatziantoniou

1st Edition

3030929566, 978-3030929565

More Books

Students also viewed these Finance questions