Question

In: Accounting

Income:                                         &n

Income:                                                                                                                                                                      Monthly Take Home Pay               $3300

Monthly Expenses:

Rent                                                    $900

Utilities                                              $250

Groceries                                           $200

Entertainment                                  $150

Car Insurance                                   $75

Cellular                                              $45

Gas                                                     $150

Clothing                                             $100

Savings                                               $400

Retirement Contribution               $200

Student Loan Payment                  $455

Car Payment                                     $375

Your budget must include the following elements:

  1. A minimum of one formula (3 formulas)
  2. Accounting number format for all dollar values
  3. Row or column headings for your budget items
  4. Row/column height/width should be adjusted to enhance readability
  5. A minimum of one function ( 3 functions)
  6. A minimum of one chart should be created based on any item(s) in your budget (2 charts)

All in excel.

Solutions

Expert Solution

Here attaching screenshots of all requirement in excel. All requirement highlighted in RED

ekkarill92 answered 1 year ago
Next > < Previous

Related Solutions

Consider a corporation whose taxable income without state income tax is                               &n
Consider a corporation whose taxable income without state income tax is                                                                                                                                                                                                                                                                                               Gross revenue ​$3,800,000 All expenses ​$1,600,000 If the marginal federal tax rate is​ 35% and the marginal state rate is​ 5%, compute the combined state and federal taxes using the two methods. State taxable income is ​$_________. ​(Round to the nearest​ dollar.) State income tax is ​$_________. ​(Round to the nearest​ dollar.) Federal taxable income is ​$____________. ​(Round to the nearest​ dollar.) Federal income tax is ​$__________....
Consider a corporation whose taxable income without state income tax is                               &n
Consider a corporation whose taxable income without state income tax is                                                                                                                                                                                                                                                                                               Gross revenue ​$3,600,000 All expenses ​$1,700,000 If the marginal federal tax rate is​ 35% and the marginal state rate is​ 5%, compute the combined state and federal taxes using the two methods. State taxable income is ​$_________. ​(Round to the nearest​ dollar.) State income tax is ​$_________. ​(Round to the nearest​ dollar.) Federal taxable income is ​$____________. ​(Round to the nearest​ dollar.) Federal income tax is ​$__________....
Babe’s Batting Cages projects the following income statement for 2018:                                &n
Babe’s Batting Cages projects the following income statement for 2018:                                                    Sales                       $ 241,745                           Operating costs excl.depr. & amort.      140,212 EBITDA                         101,533                           Depr. & Amort.              16,000 EBIT                               85,533                           Interest                             2,200 EBT                                 83,333                              Taxes (40%)                  33,333 Net Income                $ 50,000                                                      2018 Balance Sheet Assumptions: Accounts receivable increase by $5,000 Inventory decreases by $2,000 Accounts payable increases by $2,000 Accruals increase by $1,000 Net fixed assets increase by $20,000 Notes payable increase...
1) Suppose that income increases and buyers demand less of this good. This is a(n) -----...
1) Suppose that income increases and buyers demand less of this good. This is a(n) ----- good. normal luxury inferior laconic 2) Initially a market is in equilibrium. Then sellers anticipate a lower price in the future for this good, and at the same time the price of a substitute for this good increased, and demand shifts less than supply. As a result the equilibrium price ----- and the equilibrium quantity -----. rises, rises rises, falls falls, rises falls, falls...
Suppose we collect a random sample of n = 9 and find an average income of...
Suppose we collect a random sample of n = 9 and find an average income of $49,000 with a sample standard deviation s = $12,000. Provide each of the following using this information. A 95% confidence interval estimate of the population mean µ. What is the value for the margin of error? Interpret your results. A 90% confidence interval estimate of the population mean µ. A 99% confidence interval estimate of the population mean µ.
An Exchange Traded fund with an objective of both growth and income is a(n) An open-end...
An Exchange Traded fund with an objective of both growth and income is a(n) An open-end investment company Value Fund Balanced Fund
Given ˆpp^ = 0.3714 and N = 35 for the high income group, Test the claim...
Given ˆpp^ = 0.3714 and N = 35 for the high income group, Test the claim that the proportion of children in the high income group that drew the nickel too large is smaller than 50%. Test at the 0.1 significance level. a) Identify the correct alternative hypothesis: μ>.50μ>.50 p=.50p=.50 p<.50p<.50 p>.50p>.50 μ=.50μ=.50 μ<.50μ<.50 Give all answers correct to 3 decimal places. b) The test statistic value is:      c) Using the P-value method, the P-value is:   d) Based on this,...
The condensed product-line income statement for Dish N’ Dat Company for the month of March is...
The condensed product-line income statement for Dish N’ Dat Company for the month of March is as follows: Dish N’ Dat Company Product-Line Income Statement For the Month Ended March 31, 2016 1 Bowls Plates Cups 2 Sales $70,960.00 $105,450.00 $31,760.00 3 Cost of goods sold 32,990.00 42,680.00 16,710.00 4 Gross profit $37,970.00 $62,770.00 $15,050.00 5 Selling and administrative expenses 27,350.00 42,530.00 16,670.00 6 Income from operations $10,620.00 $20,240.00 $(1,620.00) Fixed costs are 30% of the cost of goods sold...
the accountant's Company Income Statement For the Year Ended December 31, 2018 Sales                            &n
the accountant's Company Income Statement For the Year Ended December 31, 2018 Sales                                                               $8,500,000 Manufacturing Expenses Variable                                $3,250,000 Fixed overhead                       640,000       3,890,000 Gross Margin                                                  $4,610,000 Selling and administrative expenses Commissions                           $580,000 Fixed marketing expenses       300,000 Fixed admin expenses               450,000      1,330,000 Net Operating Income                                     $3,280,000 Fixed Interest expenses                                       230,000     Income before Taxes                                      $3,050,000      Income Taxes (21%)                                            640,500 Net Income                                                     $2,409,500 Your company is considering out-sourcing the sales and marketing to an agency specializing in these...
The term inflation is used to describe a(n): a. ​decline in nominal income. b. ​economic problem...
The term inflation is used to describe a(n): a. ​decline in nominal income. b. ​economic problem faced only by the elderly population. c. ​rise in the value of money. d. ​general reduction in prices. e. ​sustained increase in the price level.
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT