Scribd
Upload
51 views3 pages

Budget Planning for New Career Start

The document describes a scenario summary using the Scenario Manager tool in Excel. It tracks an individual's monthly income and expenses over different career stages. The original monthly income is £3,000. The first career start income is £2,000, resulting in total expenses of £1,710 and amount left over of £290. After 5 years, the income increases to £2,500, keeping expenses the same and increasing the amount left over to £790. The third career stage has income return to the original £3,000, again keeping expenses the same and amount left over at the original £1,290.

Uploaded by

Khánh Linh Nguyễn Ngọc
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
51 views3 pages

Budget Planning for New Career Start

The document describes a scenario summary using the Scenario Manager tool in Excel. It tracks an individual's monthly income and expenses over different career stages. The original monthly income is £3,000. The first career start income is £2,000, resulting in total expenses of £1,710 and amount left over of £290. After 5 years, the income increases to £2,500, keeping expenses the same and increasing the amount left over to £790. The third career stage has income return to the original £3,000, again keeping expenses the same and amount left over at the original £1,290.

Uploaded by

Khánh Linh Nguyễn Ngọc
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 3

Scenario Summary

Current Values: Original 1st Career Start 2nd 3rd


Changing Cells:
$G$14 £3,000 £3,000 £2,000 £2,500 £3,000
Result Cells:
$G$28 £1,710.0 £1,710.0 £1,710.0 £1,710.0 £1,710.0
$G$31 £1,290 £1,290 £290 £790 £1,290
Notes: Current Values column represents values of changing cells at
time Scenario Summary Report was created. Changing cells for each
scenario are highlighted in gray.
Living costs

Task: A bank accountant wants to record his living costs. The areas that this accountan
He wants to compare the Total Expenses and Amount left Over if he has the Monthly
and as 3000 (New company).

He has asked you to help. As a proffesional Excel user, you use Scenario manager to cre
Perform Scenario manager and provide the summary with carefully corresponding na

First career Start

Monthly income £3,000

Rent £700.0
Travel £70.0
Food £250.0
Shopping £200.0
Going out £400.0
Electricity £20.0
Phone £35.0
Gas £20.0
Water £15.0

Total Expenses £1,710.0

Amount left over £1,290


as that this accountant wants to spend are recorded in First career start table.
he has the Monthly income as 2000 (First Career Start), 2500 (Over 5 years)

enario manager to create a summary to describe.


ully corresponding names of the areas spent

You might also like