Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

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

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 for the income statement and balance sheet

image text in transcribedimage text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

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

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

Entrepreneurship

Authors: Andrew Zacharakis, William D Bygrave

5th Edition

9781119563099

More Books

Students also viewed these Finance questions