MATH125 Mcclelland U4 project
.docx
keyboard_arrow_up
School
American Military University *
*We aren’t endorsed by this school
Course
125
Subject
Accounting
Date
Feb 20, 2024
Type
docx
Pages
3
Uploaded by ColonelLorisMaster170
NAME: Christeon Mcclelland
MATH125: Unit 4 Assignment Answer Form
Cash Conundrums: Financial Literacy
Assignment Instructions
For this assignment, you will create a personal budget and compare it to the 50/30/20 budgeting strategy.
1.
Answer ALL
questions below regarding creating a budget.
2.
Show ALL step-by-step
calculations, and round all of your final answers correctly to the whole number. All monetary answers should be rounded to the nearest dollar. 3.
For full credit, write all explanations
in the spaces provided. 4.
Enter your answers in the space provided in this document, and submit to the appropriate area. Scanned or handwritten work will not be accepted. 5.
If you need assistance, please contact your course instructor.
Creating a Budget
You will create a personal budget based on your current salary, or based on your state’s median salary. You will create a personal budget based one of the following: (1) your current salary, OR
(2) your state’s median salary. Review the median income information on this site.
Step 1 (6 points)
Determine your monthly net income (known as your monthly take-home pay). Your take-home pay is your gross pay (Box B) minus taxes, Social Security, and benefits, including health insurance if provided. A realistic amount would be 10-30% less than your gross monthly wages). Income
A. Annual
salary
(Base this one of the following:
(1)
your current salary, OR
(2)
your state’s median salary) $40,476
B. Gross monthly
salary/wages
(Annual salary divided by 12):
$3373
C. Monthly take-
home pay
(This is the monthly gross
pay listed in Box B minus FICA, taxes, Social Security, and health insurance):
$2253
Step 2: The 50/30/20 Strategy and Monthly Expenses (10 points)
Review the information at this link on the 50/30/20 budgeting strategy
.
Think about each of these categories. Calculate your monthly expenses for each category below, and complete the following table. It might help you to think about items on a weekly basis and then multiply by 4 to calculate a monthly budget amount. Remember, if you are not comfortable with sharing real numbers, you can do this as a hypothetical experience with realistic estimates. Budgeted Category
Examples
Budgeted Amount
Housing
Rent or mortgage payment
$0
Food
Groceries, lunches, coffees, dinners out, etc.
$300
Transportation
Gas, auto care, parking, tolls, etc.
$120
Basic utilities
Phone, electricity, water, Internet, etc.
$195
Insurance
Health, auto, home, and life insurance
$300
Child care
Day care, babysitting, college tuition, etc.
$0
Travel
Airfare, hotels
$0
Entertainment
Sporting events, dinners out, movies, and memberships
$100
Personal care
Haircuts, massages, etc.
$50
Savings
General savings, saving for car, college, wedding, etc.
$200
Other
Car note
$332
Step 3: Categorizing Needs, Wants & Savings (15 points)
Based on the 50/30/20 strategy, expenses can be needs
or wants
. However, some categories may not easily fit in with needs
or wants
. For example, daycare may be a need
, but babysitting for date night may be a want
. For each category, break down the total budgeted (in Step 2 above) into needs
and wants
. Budgeted Category
Budgeted Amount
(Step 3)
Amount toward Need
Amount toward Want
Housing
$0
$0
$0
Food
$300
$200
$100
Transportation
$120
$120
$0
Basic Utilities
$190
$130
$60
Insurance
$300
$300
$0
Child care
$0
$0
$0
Travel
$0
$0
$0
Entertainment
$100
$0
$100
Personal Care
$50
$20
$30
Savings
$200
Other
$332
$332
$
Step 4: Calculation of Needs, Wants & Savings (12 points)
Sum your category totals below:
Transfer those subtotals for the categories in the following table.
Sub-Total
Needs
$1102
Wants
$290
Savings
$200
Step 5: Percentage of Wants, Needs & Savings (12 points)
Calculate the percentage of your budget assigned to needs, wants, and savings below.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
Please answer I really need help
arrow_forward
Can someone help me with best effort? Answer correctly and completely for all with all working. Answer in text not image. Thanks!
arrow_forward
Reflection: Write your answer on a separate sheet of paper.
Make your own monthly personal cash budget using the General Form of the
Cash Budget below. You can itemize your sources of cash and your expenses.
CASH BUDGET
Week
Week
Week
Week
Total
1
2
3
4
Cash Receipts (itemized)
XXX
Less-Cash Disbursement
XXX
(itemized)
Net Cash Flow
XXX
Add-Beginning Cash
Ending Cash
XXX
XXX
Required Ending Cash
Balance
XXX
Required Total Financing
Excess Cash Balance
XXX
arrow_forward
Can someone help me, please?
arrow_forward
If you need tor revise your budget,there are certain expenses you should look at first.Order the below categories of expenses into the correct order you would address them when revising a budget.
arrow_forward
Please do not give solution in image format thanku
arrow_forward
1. Prepare A
Budgeted Statement
Of Cash flow?
Analyze, Think, Communicate
ATC 7-1 Business Applications Case Preparing and using pro forma statements
Mary Helu and Jason Haynes rccently graduatcd from the same university. After graduation thcy decided not to scck jobs at cstablishcd
organizations but, rather, to start thcir own small busincss hoping they could have morc flexibility in their personal livcs for a few ycars.
Mary's family has opcrated Mexican restaurants and taco trucks for the past two gencrations, and Mary noticcd thcre were no taco truck
Scrviccs in thc town where their university was located. To reduce the amount they would need for an initial investmcnt, they decided to start
a busincss operating a taco cart rathcr than a taco truck, from which they would cook and scrve traditional Mexican-stylc strect food.
They bought a used taco cart for $18,000. This cost, along with the cost for supplics to get startcd, a business license, and street vendor
licensc brought their…
arrow_forward
HI TUTORS! I BADLY NEEDED YOUR HELP. HELP ME THANKS
arrow_forward
For Req #4, Can you please highlight what items I should enter into the budgeted income statement for May? Your spreadsheet has far more lines than what the question does and I am confused.
Item2
3.33points
ItemSkipped
Print
Item 2
Problem 8-19 (Algo) Cash Budget; Income Statement; Balance Sheet [LO8-2, LO8-4, LO8-8, LO8-9, LO8-10]
Minden Company is a wholesale distributor of premium European chocolates. The company’s balance sheet as of April 30 is given below:
Minden CompanyBalance SheetApril 30
Assets
Cash
$ 9,200
Accounts receivable
76,250
Inventory
49,750
Buildings and equipment, net of depreciation
228,000
Total assets
$ 363,200
Liabilities and Stockholders’ Equity
Accounts payable
$ 63,750
Note payable
23,900
Common stock
180,000
Retained earnings
95,550
Total liabilities and stockholders’ equity
$ 363,200
The company is in the process of preparing a budget for May and has assembled the following data:
Sales are budgeted at…
arrow_forward
Please include calculations
a. What are the total expected cash collections for the year under this revised budget?
b. What is the total required production for the year under this revised budget?
c. What is the total cost of raw materials to be purchased for the year under this revised budget?
d. What are the total expected cash disbursements for raw materials for the year under this revised budget?
arrow_forward
please answer within 30 minutes.
arrow_forward
This is for financial mathematics 2, thank youuuu
arrow_forward
Suggest five internal strategies that may be employed by management to improve an organization monthly cash flow and militate against or reduce any possible shortfall reflected in the budget prepared
arrow_forward
help me with this with accurate solution pls
thank you
arrow_forward
Please do not give solution in image format thanku
arrow_forward
help me this with accurate solution pls
thank you
arrow_forward
Data
Year 2 Quarter
Year 3 Quarter
1
2
3
4
1
2
Budgeted unit sales
40,000
60,000
100,000
50,000
70,000
80,000
• Selling price per unit
• Accounts receivable, beginning balance
• Sales collected in the quarter sales are made
• Sales collected in the quarter after sales are made
• Desired ending finished goods inventory is
• Finished goods inventory, beginning
• Raw materials required to produce one unit
• Desired ending inventory of raw materials is
• Raw materials inventory, beginning
• Raw material costs
• Raw materials purchases are paid
and
• Accounts payable for raw materials, beginning balance
$12 per unit
$65,000
75%
25%
30% of the budgeted unit sales of the next quarter
12,000 units
5 pounds
10% of the next quarter's production needs
23,000 pounds
$0.80 per pound
60% in the quarter the purchases are made
40% in the quarter following purchase
$81,500
•Direct labor cost per hour
•Direct labor hour per unit
$15 per hour
0.2 hour per unit
$2 per hour
$60,000
•Variable MOH rate…
arrow_forward
Hello i have attached two pictures. They are both used together to answer the question. The first picture is the information to use too answer the question. The second attachment is the for the answer. I hope it is understandable and whoever answer this can please explain how they got the answers. I need the help. I have marked a yellow x on what i have done already. I DO NOT HELP WITH WHAT IS CROSSED IN YELLOW
arrow_forward
Fast solve plz
arrow_forward
Iguana, Incorporated, manufactures bamboo picture frames that sell for $25 each. Each frame requires 4 linear feet of bamboo, which costs $2.50 per foot. Each frame takes approximately 30 minutes to build, and the labor
rate averages $14 per hour. Iguana has the following inventory policies: Ending finished goods inventory should be 40 percent of next month's sales. Ending direct materials inventory should be 30 percent of next month's
production. Expected unit sales (frames) for the upcoming months follow: \table[[March, 350], [April, 400], [May, 450], [June, 550], [July, 525], [August, 575]] Variable manufacturing overhead is incurred at a rate of $0.40 per
unit produced. Annual fixed manufacturing overhead is estimated to be $10,800 ($900 per month) for expected production of 4,000 units for the year. Selling and administrative expenses are estimated at $950 per month
plus $0.60 per unit sold. Iguana, Incorporated, had $11,900 cash on hand on April 1. Of its sales, 80 percent is in…
arrow_forward
Create an Excel spreadsheet that calculates the internal
rate of return for the following set of cashflows: Period
012345 Cashflow $1123.01 $100 $100 $100 $100 $
1,100 Note your spreadsheet should calculate the
present value of each of the individual cashflows as well
as the sum based on your IRR input. Once you have
completed your IRR calculation check your work with
the Excel IRR function
arrow_forward
Define the following with formulaes if possible: Please write full definations.
1. Sales Budget
2. Cash Receipt Budget
3. Purchases Budget
4. Cash Payment Budget
5. Summary Cash Budget
6. Short Term Financial Needs
7. Budgeted Income Statement
8. Budgeted Balance Sheet
arrow_forward
answer quick with explanation
arrow_forward
A cash budget, by quarters, is given below for a retail
company (000 omitted). The company requires a
minimum cash balance of $8,000 to start each
quarter.Required:Fill in the missing amounts. Note: Enter
your answers in thousands of dollars. Cash deficiencies
and Repayments should be indicated by a minus sign.
Prev Question 10 of 10 Total 10 of 10 Visit question
mapThis is the last question in the assignment. To
submit, use Alt + S. To access other questions,
proceed to the question map button.Next McGraw Hill
arrow_forward
Help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer in proper format with all workings
arrow_forward
Please do not give solution in image format thanku
arrow_forward
1. What do you understand by a project budget? Please outline the steps needed to prepare a project budget and indicate the types of costs associated with budgets.
2. Prepare a multi-year budget for a project for a period of 3 years (2020-2022) in an Excel worksheet incorporating the following information. Please upload your excel document.
3. Please prepare a consolidated budget pivot table in Excel by budget class and year. Please upload your excel document.
Budget Class – Staff Costs
• Salary of the Project Manager @ USD 5,000 per month.
• Salary of the Admin Finance Officer @ USD 3,500 per month.
• Salary of Admin. & Finance Assistant @USD 1,000 per month
• Salary of Driver @USD 500 per month
Budget Class – Equipment & Furniture
Cost of the office equipment and furniture required for the project is USD 30,000 for three years to be procured during the 1st year of the project.
Budget Class – Operating Costs (training)
Two trainers are required for each training. Each…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Related Questions
- Please answer I really need helparrow_forwardCan someone help me with best effort? Answer correctly and completely for all with all working. Answer in text not image. Thanks!arrow_forwardReflection: Write your answer on a separate sheet of paper. Make your own monthly personal cash budget using the General Form of the Cash Budget below. You can itemize your sources of cash and your expenses. CASH BUDGET Week Week Week Week Total 1 2 3 4 Cash Receipts (itemized) XXX Less-Cash Disbursement XXX (itemized) Net Cash Flow XXX Add-Beginning Cash Ending Cash XXX XXX Required Ending Cash Balance XXX Required Total Financing Excess Cash Balance XXXarrow_forward
- Can someone help me, please?arrow_forwardIf you need tor revise your budget,there are certain expenses you should look at first.Order the below categories of expenses into the correct order you would address them when revising a budget.arrow_forwardPlease do not give solution in image format thankuarrow_forward
- 1. Prepare A Budgeted Statement Of Cash flow? Analyze, Think, Communicate ATC 7-1 Business Applications Case Preparing and using pro forma statements Mary Helu and Jason Haynes rccently graduatcd from the same university. After graduation thcy decided not to scck jobs at cstablishcd organizations but, rather, to start thcir own small busincss hoping they could have morc flexibility in their personal livcs for a few ycars. Mary's family has opcrated Mexican restaurants and taco trucks for the past two gencrations, and Mary noticcd thcre were no taco truck Scrviccs in thc town where their university was located. To reduce the amount they would need for an initial investmcnt, they decided to start a busincss operating a taco cart rathcr than a taco truck, from which they would cook and scrve traditional Mexican-stylc strect food. They bought a used taco cart for $18,000. This cost, along with the cost for supplics to get startcd, a business license, and street vendor licensc brought their…arrow_forwardHI TUTORS! I BADLY NEEDED YOUR HELP. HELP ME THANKSarrow_forwardFor Req #4, Can you please highlight what items I should enter into the budgeted income statement for May? Your spreadsheet has far more lines than what the question does and I am confused. Item2 3.33points ItemSkipped Print Item 2 Problem 8-19 (Algo) Cash Budget; Income Statement; Balance Sheet [LO8-2, LO8-4, LO8-8, LO8-9, LO8-10] Minden Company is a wholesale distributor of premium European chocolates. The company’s balance sheet as of April 30 is given below: Minden CompanyBalance SheetApril 30 Assets Cash $ 9,200 Accounts receivable 76,250 Inventory 49,750 Buildings and equipment, net of depreciation 228,000 Total assets $ 363,200 Liabilities and Stockholders’ Equity Accounts payable $ 63,750 Note payable 23,900 Common stock 180,000 Retained earnings 95,550 Total liabilities and stockholders’ equity $ 363,200 The company is in the process of preparing a budget for May and has assembled the following data: Sales are budgeted at…arrow_forward
- Please include calculations a. What are the total expected cash collections for the year under this revised budget? b. What is the total required production for the year under this revised budget? c. What is the total cost of raw materials to be purchased for the year under this revised budget? d. What are the total expected cash disbursements for raw materials for the year under this revised budget?arrow_forwardplease answer within 30 minutes.arrow_forwardThis is for financial mathematics 2, thank youuuuarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage