Rebecca is a part time college student and she has many part time jobs. Rebecca is not very good at budgeting her money. as a result, she is asking for assistance. my goal is to be able to save some

of her income to generate 25,000. Rebecca has been saving money but wants to make sure she is on the right track towards her goal. She is asking you, the new new financial counselor at ABC Inc to help her evaluate her expenses, debts, savings, and assets. desperately needs to keep a detailed budget so that she reaches her goal in 1 or 2 years.

- create her a detailed income statement and balance sheet to determine her financial position using the provided spreadsheet

- what are three ways to effectively reduce Rebecca's expenses without experiencing dramatic changes in her lifestyle

- What are three ways to effectively reduce her expenses without experiencing dramatic changes in her lifestyle.

please use the excel spreadsheet provided

Assets

Cash Inflows

Liquid assets

Checking account balance

Salary (take-home)

Savings/money market accounts, funds

Other income :

Cash value of life insurance

Other income :

Other

Total Income

Total liquid assets

Cash Outflows

Household assets and possessions

Current market value of home

Fixed expenses

Market value of automobiles

Mortgage or rent

Furniture

Loan payments

Computer, electronics, camera

Insurance

Jewelry

Other

Other

Other

Other

Total fixed outflows

Total household assets

Variable expenses

Food

Investment assets

Clothing

Savings certificates

Electricity

Stocks and bonds

Telephone

Assets

Cash Inflows

Mutual funds

Transportation

Other

Personal care

Total investment assets

Medical expenses

Total assets

Recreation/entertainment

Gifts

Liabilities

Donations

Current liabilities

Other

Charge account and credit card balances

Other

Loan balances

Total variable outflows

Other

Total current liabilities

Total Outflows

Long-term liabilities

Mortgage

Surplus (Deficit)

Other

Total long-term liabilities

Total liabilities

Net Worth

(Assets minus liabilities)

Assets: Monthly Expenses: $2,000 Rent obligation $500 Checking account Emergency fund savings account Car Computer & iPad Liabilities: Student loan Credit card balance $1,600 Utilities/electricity $100 $5,500 Utilities/water $50 $1,250 Utilities/cable TV $165 Food $200 $6,900 Gas/maintenance $110 Credit card $1,150 $60 payment Car insurance $60 $2,305 Clothing $100 $1,895 Entertainment: Cake decorating $40 class Movies with friends $65 Income: Gross monthly salary Net monthly salary 11 Cash Innow LAR Che count balance Save/money market counts, fund Cash value of life insurance Other Total d assets Sake home) Other income Our income income Cash Outhows Bouchold assets and possession Current market value of home Market value of automovies Furniture Computer, clectronics, camere Dewelry Other Other To honeholdet Investment et cer Stocis and bonds Eccount Fked expenses Mortgage front Loan payments Insurance Other Other Totalled outros Variable experises Food Clothing Elency Tophone Water Transportation Personal Can Medic penses Recreationalen Ons Donos Other Other Totest Cambities Chacun dedit card balances balance Dhe To treba O Total Van outflows Tutto Long Bibited More Othe Totalembe Det TA Assets: Monthly Expenses: $2,000 Rent obligation $500 Checking account Emergency fund savings account Car Computer & iPad Liabilities: Student loan Credit card balance $1,600 Utilities/electricity $100 $5,500 Utilities/water $50 $1,250 Utilities/cable TV $165 Food $200 $6,900 Gas/maintenance $110 Credit card $1,150 $60 payment Car insurance $60 $2,305 Clothing $100 $1,895 Entertainment: Cake decorating $40 class Movies with friends $65 Income: Gross monthly salary Net monthly salary 11 Cash Innow LAR Che count balance Save/money market counts, fund Cash value of life insurance Other Total d assets Sake home) Other income Our income income Cash Outhows Bouchold assets and possession Current market value of home Market value of automovies Furniture Computer, clectronics, camere Dewelry Other Other To honeholdet Investment et cer Stocis and bonds Eccount Fked expenses Mortgage front Loan payments Insurance Other Other Totalled outros Variable experises Food Clothing Elency Tophone Water Transportation Personal Can Medic penses Recreationalen Ons Donos Other Other Totest Cambities Chacun dedit card balances balance Dhe To treba O Total Van outflows Tutto Long Bibited More Othe Totalembe Det TA