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/- |
Bike is not wanted. Sell it and deposit cash in checking. $1400 Start a savings account...
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 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 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 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 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: 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 * 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 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 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 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...