Question
John and Mary are a couple who own a home and are both employed. Johns monthly take home pay is $4,167 while Mary is bringing
John and Mary are a couple who own a home and are both employed. Johns monthly take home pay is $4,167 while Mary is bringing home $4,583 each month. They receive dividends of $200 in January and April on their modest investment portfolio and earn about $25 of interest each month on their savings. John expects to collect a consulting fee of $3,000 (for work already complete) in February and anticipates more consulting work later in the year (but hasnt done the work yet) which should be about $4,000 to be received in May.
Can someone check my analysis of the above income and let me know if it is correct on my spreadsheet? Not sure if i am supposed to document the consulting fees for work not yet complete.
Monthly income | |||||||
Item | January | February | March | April | May | June | Totals |
Salary - John | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $25,002 |
Salary - Mary | $4,583 | $4,583 | $4,583 | $4,583 | $4,583 | $4,583 | $27,498 |
Dividends | $200 | $200 | $400 | ||||
Interest | $25 | $25 | $25 | $25 | $25 | $25 | $150 |
Other | $3,000 | $4,000 | $7,000 | ||||
Total | $8,975 | $11,775 | $8,775 | $8,975 | $12,775 | $8,775 | $60,050 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started