Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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, 2016. Use the worksheet that Prabakar and Gita provided plus the additional information to fill in the missing amounts on the Jain's cash-flow statement for the year ended December 31, 2016. (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. $27,250 25,888 Cash received & income taxes: Prabakar's salary Gita's salary Prabakar's bonus IBM dividend Savings interest Income taxes: Prabakar Gita 4,088 20 Cash payments: Rent $1,370 School Loan 165 Train pass (year) 900 Car loan payment 315 Auto insurance Year) 330 Central Maine Power 220 T-Mobile 105 17 4,905 4,660 Here is some additional Information For income items, they know yearly amounts. For some expenses, they know the annual amount (for example, Gita's 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 doesn't change much from month to month . Based on their employer provided health insurance, they incur a copy of $20 per visit. They estimated that they saw the doctor combined) 4 times during the year. Prabkr 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 $200 a month on clothing. She never has cash and uses her credit cards for everything. They went on a Norwegian Cruise that cost $2,200; they took an additional $500 for spending. That was their only vacation. Name: Prabakar and Gita Jain Date: For the year ended December 31, 2016 Dollars Percent INCOME % Prabakar's salary Gita's salary Prabakar's bonus % % Interest and dividends % Total Income 100% EXPENDITURES Fixed Expenses Rent expense Prabakar's income taxes Gita's Income taxes Automobile loan payment Education loan % % % % % % % Phone Transportation Automobile insurance and registration Total fixed expenses Variable Expenses % % Variable Expenses Food % 9 % Utilities Gasoline and maintenance Vacations % TE M Clothing Miscellaneous (Prabakar's withdrawals) Medical expenses Total variable expenses Total Expenses SURPLUS (DEFICIT) M Based on this cash flow statement, Prabakar and Gita have a cash nows in and out their bank balance should have for the year. This means that if they accounted for all of their cash from December 31, 2015 to December 31, 2016

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

Step: 3

blur-text-image

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

Bakers Health Care Finance Basic Tools For Nonfinancial Managers

Authors: Thomas K. Ross

6th Edition

1284233162, 978-1284233162

More Books

Students also viewed these Finance questions