Cash-Flow Statement | ||
Name: Prabhakar and Gita Jain | ||
Date: For the year ended December 31, 2016 | ||
Dollars | Percent | |
INCOME | ||
Prabhakar's salary | 27750 | 47.6% |
Gita's salary | 26363 | 45.2% |
Prabhakar's bonus | 4163 | 7.1% |
Interest and dividends | 33 | 0.1% |
Total income | 58309 | 100.0% |
EXPENDITURES | ||
Fixed Expenses | ||
Rent expense | 16800 | 28.8% |
Prabhakar's income taxes | 4995 | 8.6% |
Gita's income taxes | 4745 | 8.1% |
Automobile loan payment | 3780 | 6.5% |
Education loan | 2616 | 4.5% |
Phone | 1656 | 2.8% |
Transportation | 900 | 1.5% |
Automobile insurance and registration | 435 | 0.7% |
Total fixed expenses | 35927 | 61.6% |
Variable Expenses | ||
Food | 5200 | 8.9% |
Utilities | 3480 | 6.0% |
Gasoline and maintenance | 3120 | 5.4% |
Vacations | 2700 | 4.6% |
Clothing | 1800 | 3.1% |
Miscellaneous (Prabhakar's withdrawals) | 5200 | 8.9% |
Medical expenses | 180 | 0.3% |
Total variable expenses | 21680 | 37.2% |
Total Expenses | 57607 | 98.8% |
SURPLUS (DEFICIT) | 702 | 1.2% |
All percent values are rounded off to one decimal place in the absence of specific instructions regarding the same. Kindly round off as required.
Based on this cash-flow statement, Prabhakar and Gita have a cash surplus for the year. This means that if they accounted for all of their cash flows in and out, their bank balance should have increased by $702 from December 31, 2015 to December 31, 2016.
A Aa 6. Cash-flow statement Prabakar and Gta lain have been married for two years. They...
Deon and Keyshia wallace have been married for two years. They have been trying to save but feel that there is never anything leftover after expenses. Keyshia 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 Deon and Keyshia provided plus the additional information to fill in the missing amounts on the Wallace's cash-flow statement for the year ended December 31,...
Deon and Keyshia Wallace have been married for two years. They have been trying to save but feel that there is never anything leftover after expenses. Keyshia 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 Deon and Keyshia provided plus the additional information to fill in the missing amounts on the Wallace's cash-flow statement for the year ended December 31,...
Skip and Jackie Garcia have been married for over two years. They have been trying to save for a down payment on a house, but they feel that there is never anything left over to save. They talked with their parents who suggested that they prepare an income and expense statement. Skip and Jackie put together the following worksheet. Worksheet $ 16 218 $ 410 3,000 4,356 68 Car payment Skip's commission Commuter train pass (year) Apple dividend Renter's Insurance...
9. Preparing a budget A cash-flow budget uses the same format as a cash-flow statement. It is prepared on a monthly basis and it reflects budgeted income and expenses. In addition to the cash-flow statement, Soott and Mary made a list of budget assumptions, listed for you here: . scott's income will increase by 5%, effective January 1 His bonus is generally 10% of his income in the previous year, and he recerves it in January. Mary's raise will be...
A cash-flow budget uses the same format as a cash-flow statement. It is prepared on a monthly basis and it reflects budgeted income and expenses.In addition to the cash-flow statement, Deon and May made a list of budget assumptions: . Deon's income will increase by 5%, effective January 1 . His bonus is generally 10% of his income in the previous year, and he receives it in January. . May's raise will be 3%, effective January 1, Interest and dividend...
9. Preparing a budget Aa Aa A cash-flow budget uses the same format as a cash-flow statement. It is prepared on a monthly basis and it reflects budgeted income and expenses. In addition to the cash-flow statement, Dan and Lucy made a list of budget assumptions, listed for you here: Dan's income will increase by 5%, effective January 1. His bonus is generally 10% of his income in the previous year, and he receives it January • Lucy's raise will...
A cash-flow budget uses the same format as a cash-flow statement. It is prepared on a monthly basis and it reflects budgeted income and expenses. In addition to the cash-flow statement, Deon and May made a list of budget assumptions, listed for you here: • Deon’s income will increase by 5%, effective January 1. His bonus is generally 10% of his income in the previous year, and he receives it in January. • May’s raise will be 3%, effective January...
7. Preparing a cash budget Brock and Sam 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. Income and Expense Statement Name(s): Brock and Sam Wilson For the year ending: As of December 31 Dollars Income Wages and salaries Name:...
7. Preparing a cash budget Dan and June 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. Income and Expense Statement Name(s): Dan and June Kuryaki For the year ending: As of December 31 Dollars Income Wages and salaries Name:...
10. Preparing a cash budget Brock and Sam 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. Income and Expense Statement Name(s): Brock and Sam Wilson For the year ending: As of December 31 Dollars Income Wages and salaries Name:...