Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

6. Cash-flow statement Prabakar and Gita Jain have been married for two years. They have been trying to save but feel that there is never

6. Cash-flow statement

Prabakar and Gita Jain have been married for two years. They have been trying to save but feel that there is never anything leftover after expenses. Gita is taking a night course on personal finance, and she suggested that they prepare a cash-flow statement for the year ended December 31, 2021.

Use the worksheet that Prabakar and Gita provided plus the additional information to fill in the missing amounts on the Jains cash-flow statement for the year ended December 31, 2021. (Note: Round percentages to one decimal place, and dollar amounts to the nearest whole dollar. If your answer is negative, use a minus sign.)

Prabakar and Gita put together the following worksheet.

Cash received & income taxes: Cash payments:
Prabakars salary $27,250 Rent $1,369
Gitas salary 25,888 School Loan 165
Prabakars bonus 4,088 Train pass (year) 900
P&G dividend 18 Car loan payment 315
Savings interest 15 Auto insurance (year) 330
Income taxes: Maine Power 220
Prabakar 4,905 AT&T 105
Gita 4,660

Here is some additional information:

For income items, they know yearly amounts. For some expenses, they know the annual amount (for example, Gitas annual commuter-train pass). They listed those amounts and noted them as such.
Unfortunately, for other expenses, they provided the payment they made last month, stating that the amount doesnt change much from month to month.
Based on their employer-provided health insurance, they incur a copay of $20 per visit. They estimated that they saw the doctor (combined) 4 times during the year.
Prabakar estimated that he spends about $60 a week on gas and maintenance for their two cars, and he takes out $100 for spending money every week.
Gita estimated that she spends about $100 a week on groceries and $150 a month on clothing. She never has cash and uses her credit cards for everything.
They went on a Princess Cruise that cost $1,975; they took an additional $500 for spending. That was their only vacation.
Cash-Flow Statement
Name: Prabakar and Gita Jain
Date: For the year ended December 31, 2021
Dollars
INCOME
Prabakars salary 27,250
Gitas salary 25,888
Prabakars bonus 4,088
Interest and dividends
Total Income

$

EXPENDITURES
Fixed Expenses
Rent expense
Prabakars income taxes 4,905
Gitas income taxes 4,660
Automobile loan payment
Education loan
Phone
Transportation 900
Automobile insurance and registration 330
Total fixed expenses

$

Variable Expenses
Food $5,200
Utilities
Gasoline and maintenance
Vacations 2,475
Clothing
Miscellaneous (Prabakars withdrawals) 5,200
Medical expenses 80
Total variable expenses

$

Total Expenses

$

SURPLUS (DEFICIT)

$

Based on this cash-flow statement, Prabakar and Gita have a cash ____(surplus or deficit) for the year. This means that if they accounted for all of their cash flows in and out, their bank balance should have (decreased or increased) by ($57,259.$1975. $33, $2501) from December 31, 2020 to December 31, 2021.

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

Cost Accounting

Authors: M.E. Thukaram Rao

3rd Edition

8122433820, 978-8122433821

More Books

Students also viewed these Accounting questions

Question

How does Disney try to redress prejudice and discrimination?

Answered: 1 week ago