Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLEASE HELP, THX!!!!! 10. Preparing a cash budget Aa Aa E Income and Expense Statement Name(s): Kerry and Kim Lee For the year ending: As

PLEASE HELP, THX!!!!!

image text in transcribedimage text in transcribed

10. Preparing a cash budget Aa Aa E Income and Expense Statement Name(s): Kerry and Kim Lee For the year ending: As of December 31 Kerry and Kim started to create a budget (based on last year's income and expense statement) but got stuck. They know that you have learned how to create budgets and are asking for your help. They would like you to input the correct values for the first three months of next year. Dollars Income Wages and salaries In addition to the statement, you will need to know the following information: Name: Kerry Lee Name: Kim Lee Kerry's bonus $ 19,500 17,550 1,950 They estimated their net annual income (after taxes and employer deductions) at $14,625 for Kerry and $13,163 for Kim Bonuses and commissions (1) Total Income: $39,000 Expenses Housing Utilities Insurance is paid at the end of each calendar quarter Kim purchases her commuter pass on the first of each month $9,456 1,056 528 Food Transportation Central Maine Power T-Mobile Groceries Auto loan Public transportation The parents' loan is money they borrowed from Kim's parents to pay off their student loans. How much they pay each month is determined by them The fun money listed on the statement is the money spent for a cruise to Mexico. They didn't keep track of any other entertainment expenses (such as dinners out and movies) incurred during the year. 1,896 3,780 4,200 1,576 9,263 3,500 1,225 $36,480 $2,520 Insurance Taxes Fun money Parents' loan (2) Total Expenses: Surplus (Deficit): Cruise to Mexico Note: Enter a value in each blank cell to get full credit for this exercise, and round all dollar amounts to the nearest whole dollar. Three-Month Cash Budget (By Month) Name(s): Kerry and Kim Lee For: Three months Ending: March 31 Total for Three Months January February Income Kerry's salary Kim's salary Total income Expenses Rent Utilities: Central Maine Power T-Mobile Food Automobile Public transportation Insurance Parents' loan Fun money Total expenses Cash surplus (deficit) Cumulative surplus (deficit) Looking at the completed budget, what single item would you recommend that they add to their budget? O Dividend and interest income O Pensions and annuities Savings and investments This is because: The couple needs to increase their distributions from their retirement plans. The couple needs to increase their taxable income. The couple needs to budget for contingencies and save for future goals

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Return Distributions In Finance

Authors: Stephen Satchell, John Knight

1st Edition

0750647515, 978-0750647519

More Books

Students also viewed these Finance questions

Question

Explain the factors that determine the degree of decentralisation

Answered: 1 week ago

Question

What Is acidity?

Answered: 1 week ago

Question

Explain the principles of delegation

Answered: 1 week ago

Question

State the importance of motivation

Answered: 1 week ago

Question

Discuss the various steps involved in the process of planning

Answered: 1 week ago