The Smith's are a married couple in their mid-20's. Jane is an associate at a small...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The Smith's are a married couple in their mid-20's. Jane is an associate at a small law firm in downtown Chicago. Her gross salary is $132,000. Her husband John is a human resources associate at a large manufacturing firm in the suburbs. His gross salary is $61,000. Since getting married three years ago, they have been living comfortably. Their income has consistently exceeded their expenses and they have accumulated a net worth of about $55,000, primarily as a result of rising home prices increasing the amount. of equity in their downtown condo that they purchased after their wedding. As a result of not having any cash flow issues, Jane and John have done no financial planning beyond making sure there is money left in the bank at the end of the month. Jane has just learned she is pregnant. They are excited about the prospect of having a child but are concerned about how they will make ends meet if, as they had always talked about, John stays at home to run the household and be the primary caretaker of the child. Jane has no aspirations to stay home and is seen as a rising star within her firm. She hopes to make partner in 7-8 years. Each time that Jane broaches the topic of financial planning with John, he replies that "don't worry, we've always paid the bills on time." Since John's income would go away completely, Jane is not satisfied with this conclusion. Together, they document their financial situation by using the balance sheet they built one year ago and a listing of expenses incurred during the last year. Since they primarily use a debit card, this information was easily pulled from their bank statements. 1. Create an income and expense statement based on the information given to you for activity over the last year. Remember, since an I&E statement reflects past history, this statement should reflect what was going on with Jane working, not what would happen if she quit. 2. Using last year's balance sheet and the income and expense statement from #1, create a new balance sheet that reflects their financial position today 3. Add a column to your income and expense statement to create a forward-looking budget based on the income and expense statement format which would reflect their situation if John quit, they incurred $12,000 in expenses related to the new baby and no other changes to their spending habits were made. 4. Add one more column to your income and expense statement which reflects five or more reasonable and viable changes you think John and Jane can make which will put them in a position of a non-negative net cash surplus. Feel free to buy and sell assets in addition to cutting expense categories. Reflect any net cash inflows as a result of such sales in the income section of your additional column. Make. sure your strategies are sustainable. In other words, do not simply spend down their retirement savings because those will eventually be depleted. Assumptions when creating your financial statements: • Clothing purchased has a one time reduction in market value of 80% of the purchase price immediately following the purchase. Remember that assets already on the old balance sheet are listed at market value so have already had this reduction accounted for. • Consumer electronics purchased has a one time reduction in market value of 80% of the purchase price immediately following the purchase. Remember that assets already on the old balance sheet are listed at market value so have already had this reduction accounted for. Cars lose 15% of their market value per year. • Home values in this market have stayed completely flat. Taxes and government withholdings are taken out proportionately from each person's check. (for example, if withholdings and taxes are 15% of total income, assume that both earners have 15% taken out; in other words, one is not taxed at a higher rate than the other.) MY NUMBER OF 15% IS ONLY AN EXAMPLE. The tax rate is not necessarily 15%. You need to figure out the tax rate based on the withholding reported in their expenses. Assume no investment returns ● Expenses incurred in the last year: Income taxes and government withholdings (social security, medicare): Medical expenses: Gasoline: Auto Repair: Car payment - Lexus (toward principal): Car payment - Lexus (toward interest): Groceries: Dining Out: Car insurance: Life insurance: Medical Insurance Homeowner's insurance Vacation: Mortgage payment (toward principal): Mortgage payment (toward interest): Student loan payment (toward principal): Student loan payment (toward interest): Condo association fees: Clothing - Jane: Clothing - John: Big screen TV (one time purchase): Cell Phone Service: Electricity: $33750.00 1500.00 4213.17 726.02 5445.05 4112.48 2340.14 4568.68 2506.37 1415.00 2875.00 728.00 6415.32 6847.67 27274.98 8950.77 17000.98 5875.00 4250.51 2059.21 2199.99 1182.11 1780.12 Water/sewer: Internet service: Satellite TV service: Entertainment: Miscellaneous expenses they could not account for (cash withdrawn): Contribution to 401(k) - Jane: Contribution to 401(k) - John: Roth IRA Contribution - Jane: Roth IRA Contribution- -John: 476.75 285.41 915.22 6692.36 3250.00 5500.00 1850.00 3300.00 3850.00 The Smith's are a married couple in their mid-20's. Jane is an associate at a small law firm in downtown Chicago. Her gross salary is $132,000. Her husband John is a human resources associate at a large manufacturing firm in the suburbs. His gross salary is $61,000. Since getting married three years ago, they have been living comfortably. Their income has consistently exceeded their expenses and they have accumulated a net worth of about $55,000, primarily as a result of rising home prices increasing the amount. of equity in their downtown condo that they purchased after their wedding. As a result of not having any cash flow issues, Jane and John have done no financial planning beyond making sure there is money left in the bank at the end of the month. Jane has just learned she is pregnant. They are excited about the prospect of having a child but are concerned about how they will make ends meet if, as they had always talked about, John stays at home to run the household and be the primary caretaker of the child. Jane has no aspirations to stay home and is seen as a rising star within her firm. She hopes to make partner in 7-8 years. Each time that Jane broaches the topic of financial planning with John, he replies that "don't worry, we've always paid the bills on time." Since John's income would go away completely, Jane is not satisfied with this conclusion. Together, they document their financial situation by using the balance sheet they built one year ago and a listing of expenses incurred during the last year. Since they primarily use a debit card, this information was easily pulled from their bank statements. 1. Create an income and expense statement based on the information given to you for activity over the last year. Remember, since an I&E statement reflects past history, this statement should reflect what was going on with Jane working, not what would happen if she quit. 2. Using last year's balance sheet and the income and expense statement from #1, create a new balance sheet that reflects their financial position today 3. Add a column to your income and expense statement to create a forward-looking budget based on the income and expense statement format which would reflect their situation if John quit, they incurred $12,000 in expenses related to the new baby and no other changes to their spending habits were made. 4. Add one more column to your income and expense statement which reflects five or more reasonable and viable changes you think John and Jane can make which will put them in a position of a non-negative net cash surplus. Feel free to buy and sell assets in addition to cutting expense categories. Reflect any net cash inflows as a result of such sales in the income section of your additional column. Make. sure your strategies are sustainable. In other words, do not simply spend down their retirement savings because those will eventually be depleted. Assumptions when creating your financial statements: • Clothing purchased has a one time reduction in market value of 80% of the purchase price immediately following the purchase. Remember that assets already on the old balance sheet are listed at market value so have already had this reduction accounted for. • Consumer electronics purchased has a one time reduction in market value of 80% of the purchase price immediately following the purchase. Remember that assets already on the old balance sheet are listed at market value so have already had this reduction accounted for. Cars lose 15% of their market value per year. • Home values in this market have stayed completely flat. Taxes and government withholdings are taken out proportionately from each person's check. (for example, if withholdings and taxes are 15% of total income, assume that both earners have 15% taken out; in other words, one is not taxed at a higher rate than the other.) MY NUMBER OF 15% IS ONLY AN EXAMPLE. The tax rate is not necessarily 15%. You need to figure out the tax rate based on the withholding reported in their expenses. Assume no investment returns ● Expenses incurred in the last year: Income taxes and government withholdings (social security, medicare): Medical expenses: Gasoline: Auto Repair: Car payment - Lexus (toward principal): Car payment - Lexus (toward interest): Groceries: Dining Out: Car insurance: Life insurance: Medical Insurance Homeowner's insurance Vacation: Mortgage payment (toward principal): Mortgage payment (toward interest): Student loan payment (toward principal): Student loan payment (toward interest): Condo association fees: Clothing - Jane: Clothing - John: Big screen TV (one time purchase): Cell Phone Service: Electricity: $33750.00 1500.00 4213.17 726.02 5445.05 4112.48 2340.14 4568.68 2506.37 1415.00 2875.00 728.00 6415.32 6847.67 27274.98 8950.77 17000.98 5875.00 4250.51 2059.21 2199.99 1182.11 1780.12 Water/sewer: Internet service: Satellite TV service: Entertainment: Miscellaneous expenses they could not account for (cash withdrawn): Contribution to 401(k) - Jane: Contribution to 401(k) - John: Roth IRA Contribution - Jane: Roth IRA Contribution- -John: 476.75 285.41 915.22 6692.36 3250.00 5500.00 1850.00 3300.00 3850.00
Expert Answer:
Answer rating: 100% (QA)
Based on the information provided lets create an income and expense statement for John and Jane We start with their combined gross salary and then sub... View the full answer
Related Book For
Posted Date:
Students also viewed these corporate finance questions
-
You live in a household with yourself, a partner, and two children (3 years old and 5 years old). Your monthly income is 5600$ and your monthly expense is 4700$. We know that saving for our...
-
Based on the following table, does the bank have sufficient Tier 1+2 capital according to the Basel III standards? Recall: Tier 1 standard (including capital conservation buffer) is 8.5% and Tier...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Multi-Star, Inc., had sales of $890,000, cost of sales and operating expenses of $450,000 and $200,000, respectively, and 10,000 shares of common stock outstanding. Calculate the amount of earnings...
-
Dickinson Inc. owns the following assets. Compute the composite depreciation rate and the composite life of Dickinson's assets. Estimated Useful Life 10 years Cost Asset Salvage A $70,000 $ 7,000...
-
A chemist who has five assistants is engaged in a research project that calls for nine compounds that must be synthesized. In how many ways can the chemist assign these syntheses to the five...
-
In 2011, quarterbacks Tom Brady, Drew Brees, and Payton Manning, representing a class including current NFL players, claimed that a league-imposed lockout was a horizontal group boycott among...
-
John Josephs, an audit manager for Tip, Acanoe & Tylerto, was asked to speak at a dinner meeting of the local Small Business Administration Association. The president of the association has suggested...
-
3. A particle of mass m is moving in the xy-plane such that its velocity at a point (x, y) is given as v = a(yx+2xy), where a is a non-zero constant. What is the force F acting on the particle? (A) F...
-
A department store maintains data on customers, products, and purchase records in three tables: CUSTOMER, PRODUCT, and PURCHASE. The store manager wants to find the average price of all distinct...
-
"A quantitative function that an optimization model seeks to optimize (i.e., maximize or minimize)" is the definition of OA. a constraint. OB. an objective function. OC. a yield model. OD. a tactical...
-
Explain the circumstances in which return on investment is preferable as a measure of divisional performance.
-
Does appropriate communication require strict conformity to group rules?
-
Define business strategy.
-
How do you determine communication competence?
-
Describe the working capital cycle.
-
1 meter 1 meter 1 meter 1 meter 1 meter 1 dm 1 cm 1 mm 1 um 1 nm Metric Conversions 10 decimeters 10 centimeter 10 millimeters 10 decimeters 100 centimeters 1000 millimeters 1,000,000 micrometers...
-
1. Use these cost, revenue, and probability estimates along with the decision tree to identify the best decision strategy for Trendy's Pies. 2. Suppose that Trendy is concerned about her probability...
-
When do parties have the option of choosing conciliation, mediation, or arbitration?
-
Happy Coffee is a franchised caf that has been open for just over a year. It operates seven days a week, from 7 am to 10:30 pm. On May 30, the union filed an application for certification of a...
-
The bargaining power of both sides is affected by a number of factors. Identify the factors that affect managements and the unions bargaining power.
-
Verify the color SU(3) representations for combinations of three or fewer quarks and antiquarks given in Eq. (19.28). Data from Eq. 19.28 qq=303=108 qq 3 3 603, 999 3 3 3 = 36315, qqq 3 3 3 1088 10,
-
Prove that Eq. (19.34) gives the simplest multi-gluon and gluon-quark states that contain an \(\mathrm{SU}(3)\) color singlet in the decomposition. Data from Eq. 19.34 (GG)1: (88)1 (Gqq) : [8 (383)8]...
-
A textile manufacturer is concerned about the strength of cotton yarn. In order to nd out whether fiber length is an important factor in determining the strength of yarn, the quality control manager...
Study smarter with the SolutionInn App