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:
- A minimum of one formula (3 formulas)
- Accounting number format for all dollar values
- Row or column headings for your budget items
- Row/column height/width should be adjusted to enhance readability
- A minimum of one function ( 3 functions)
- 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 agoRelated 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
ADVERTISEMENT
Latest Questions
- In general, teams can be described three ways. Name and define each.
- JAVASCRIPT: Please create an array of student names and another array of student grades. - Create...
- Topic - Construction: Structural, loads, tension 1.) Explain why pure tension members are the most efficient...
- Procter and Gamble (PG) paid an annual dividend of $ 1.62$1.62 in 2009. You expect PG...
- locate a recent case of online child pornography. Write a summary of the incident and describe...
- #Python 5. Write function called evaluate() that evaluates the following Python expressions or assignments as specified:...
- Suggest journal, research paper link reference. i need this as reference for writing a research with...
ADVERTISEMENT