Question
Bike is not wanted. Sell it and deposit cash in checking. $1400
Start a savings account for a house $250 a month.
Sell the watch and deposit cash in checking.
Make extra payment of $200 a month on Camaro loan.
Add wifi to apartment. $90 a month.
Cut back $100 a month on fuel cost.
Use cash from sell of assets to cover deficit in budget until car loan is paid off.

I provided the Cash Flow Statement numbers to be accurate. (This is to make a Budget statement) The Budget Spread sheet is what i need done.

Text Font Auto save # : Personal Financial Statement FUR LUDUET CUIUI LUULU. File Home Insert Page Layout Formulas Data Revie
Lb Calibri BIU. 12AA . .A • се wrap text- Merge & Center - Alignment Condi $ . % 88 ard Font Alignment Number A D E I 900 F F
Nun Calli n g Ideas CDEFG Budget is done for the bike sale xpected Income G ODIs the one to do is paste all goalshere Bike is
General Wap West Merge as Center Delete Formal Colibri 11. B IU. . .A. Font S%98- Conditional Forma Formatting Table cell St
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Budget Statement based on information provided :

BUDGET
Expected Income
1 Monthly Allowance $800
2 Part time job $1,000
3 Cash from sale of bike $1,400
4 Cash from sale of watch Amount not given
Total Income $3,200
The above income is excluding the cash from sale of watch
Planned Expenses
Fixed Expenses
1 Savings $250
2 Camero Loan $200
3 Wifi $90
4 Apartment Rent $350
5 Auto Insurance $150
6 Car Payment $400
Total Fixed Outflows $1,440
Variable Expenses
1 Grocery $300
2 Gas($250-$100) $150
3 Utilities water $75
Total Variable Outflows $525
Total Outflows $1,965
Income remaining $1,235
Note : With cash income received from sale of watch, the remaining income will be higher than $1,235/-
Add a comment
Know the answer?
Add Answer to:
Bike is not wanted. Sell it and deposit cash in checking. $1400 Start a savings account...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • CREATE A BUDGET SPREAD SHEET: Bike is not wanted. Sell it and deposit cash in checking....

    CREATE A BUDGET SPREAD SHEET: Bike is not wanted. Sell it and deposit cash in checking. Start a savings account for a house $250 a month. Sell the watch and deposit cash in checking. Make extra payment of $200 a month on Camaro loan. Add wifi to apartment. $90 a month. Cut back $100 a month on fuel cost. Use cash from sell of assets to cover deficit in budget until car loan is paid off. BTV mert Delete Format...

  • Use the list of items below to create a Balance Sheet and Cash Flow Statement. 2010...

    Use the list of items below to create a Balance Sheet and Cash Flow Statement. 2010 Camaro $ 8,500 Apartment Rent 350 Bicycle $ 1,400 Camaro Car Loan Balance $ 2,700 Checking account at Credit Union $ 230 Grandfathers Watch $ 2,500 Grocery $ 300 Monthly allowance from rich aunt $ 800 Part time Job Weekly Paycheck $ 250 Savings account at First National Bank $ 1,500 Student Loan Debt $ 10,500 Student Loan Funds Available $ 4,000 $ 400...

  • Please, answer with formulas. K . HOME FILE Calibri Comparison of Capital Budgeting Methods - Excel...

    Please, answer with formulas. K . HOME FILE Calibri Comparison of Capital Budgeting Methods - Excel INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW - 11-AA Wrap Text V - A Merge & Center. $. % . Conditional Formatas Cell ** Formatting Table Styles Font Alignment Number Styles X Laurman, Inc. is considering the following project: Insert Delete B I 12.5 points Cells eBook Print References 1 Laurman, Inc. is considering the following project: 2 Required investment in equipment 3 Project...

  • what is the formula for finding the beginning cash balance. cash_flow_budget_v3 - Saved B. = Page...

    what is the formula for finding the beginning cash balance. cash_flow_budget_v3 - Saved B. = Page Layout kosisochukwu oralipor - Draw Formulas Data Review View Help Team Search AutoSave Cab File Home insert Calibri Paste BIU - Com Share 4 = Custom -11 - -A A - A Wrap Text Merge & Center - Insert 33 Delete - ! Format 247 0 Sort & Find & Filter Select $ -% 818 Conditional format as Formatting Table Cell Styles Sensitivity Clipboard...

  • not sure if this is correct AutoSave 0 H e Home ndias_module_02092020.x - Excel Insert Page...

    not sure if this is correct AutoSave 0 H e Home ndias_module_02092020.x - Excel Insert Page Layout Formulas Calibri Data Review Views B I 11 H. J • - A A • - A) 19 C ard 2 Wrap Text Mergea Cente Font E22 Alignment 7% of sales 18% of sales 2 Sales Commissions CADE 3 Advertising Expense 4 Misc. selling expense 5 Office salaries expense $1,750 plus 4% of sales 6 office supplies expense $12,000 per month 5% of...

  • The answer must be provided in excel sheets Financial Management MGMT8500 Case study on NPV Weight:...

    The answer must be provided in excel sheets Financial Management MGMT8500 Case study on NPV Weight: 5% of your final grade Tech Help Inc. has been offered a new contract. The firm needs to determine whether the contract will be profitable. The new contract will generate 800 billing hours at $125 per year for 5 years. The variable costs, labour will be $32 an hour (including fringe benefits). The fixed costs include 3 vehicle for the employees to service customers...

  • 1. Calculate the operating cash flow and net working capital. ? X - Sign In FILE...

    1. Calculate the operating cash flow and net working capital. ? X - Sign In FILE * Calculating Total Cash Flows - Excel HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri - 11 - AA = % D o B IU. 3- A Alignment Number Conditional Format Cell Formatting as Table Style Font Styles BE- Paste Cells Editing Clipboard A1 D E F G н Jetson Spacecraft Corp. shows the following information on its 2011 income statement: sales =...

  • only anser the yellow shaded boxes Arial B92. SM2594 [Compatibility Mode] - Excel HOME INSERT PAGE...

    only anser the yellow shaded boxes Arial B92. SM2594 [Compatibility Mode] - Excel HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW X Cut -10A A = = = Wrap Text En Copy - BIU - 2 - Et Merge & Center - $ - % , Format Painter 8. Con Fom Clipboard Font E l Alignment Number Num - X for ABC I See The Light Projected Income Statement For the Period Ending December 31, 20x1 $ 1,125,000.00 723,250.00 $...

  • Week 5 Homework Assignment-Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri - 11...

    Week 5 Homework Assignment-Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri - 11 A A Wrap Text Auto Fil- General Paste BIU - A Merge & Center E Conditional Format as Cell Formatting Insert Delete Formar Clear- Table Styles Clipboard Font Alignment Number Styles Cells K11 A D F G H J 1 Comprehensive Budgeting Problem 20 points Silverman Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain...

  • Please answer with formula. tion Ch 8 Saved Х - Cash Budget with Supporting Cash Collections...

    Please answer with formula. tion Ch 8 Saved Х - Cash Budget with Supporting Cash Collections and Disbursements Schedul... ? INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW FILE HOME Sign In Calibri - 11 - AA % Paste BIU. Cells Alignment Number Conditional Format Cell Formatting as Table Styles Styles Clipboard Font A1 S&P Enterprises needs a cash budget for March. The following information is с D E B 21 Total budgeted selling & administrative expenses in March $12,500 22...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT