Wilson Johnson, a childhood, friend has asked you to assist with his personal finances. Single and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Wilson Johnson, a childhood, friend has asked you to assist with his personal finances. Single and 30 years old, he is employed as an accountant with a technology company. Wilson has moved from a two-bedroom $650 apartment to a condo costing $1.100 per month. The association owns two golf courses, a lake and an activities center. His other monthly expenses include: Renter's Insurance Car payment Utilities Cell phone House phone Food Clothes $25 550 235 200 50 225 125 260 Car Expenses Entertainment 350 Wilson is surprised how much he spends on clothing and entertainment. He uses credit cards...the balance is $7,500 and climbing. Wilson makes the required monthly payments. He would like to reduce the balance and pay it off Wilson's other goal is to save for retirement by putting $4,500 per year away and retiring at 60. He wants to start saving in 5 years and does not think the delay will greatly affect the amount of retirement savings Wilson has a current balance in his checking account of $3,500 and $400 in his savings account. He has furniture valued at $1,800 and owns $1,500 of tech stocks, which he thinks, will grow by leaps and bounds. Case Questions-Section 1: la) Prepare a personal cash flow statement for Wilson Johnson Personal Cash Flow Statement (Monthly) Cash Inflows Cash Outflows 1b) Prepare a personal balance sheet for Wilson Liquid Assets Household Assets Investment Assets Liabilities & Net Worth Current Liabilities Long Term Liabilities Net Worth 2) Based on these statements, make specific recommendations to Wilson about what he needs to achieve his goals of paying off his credit card debt and saved for retirement 3) What additional goals could you recommend for Wilson in the short term and long term? 4a) Consider Wilson's goal to retire in 30 years by saving $4,500 per year starting 5 years from now. Based on your analysis, is this a realistic goal? If not, what would you advise? 4b) In order for Wilson to know what his investment will be worth in 30 years, what additional assumption or information does he need? 4c) Assuming Wilson can invest the $4,500 per year for 30 years starting 5 years from now and achieve an 8 percent return, how much will he accumulate in 25 years? Wilson Johnson, a childhood, friend has asked you to assist with his personal finances. Single and 30 years old, he is employed as an accountant with a technology company. Wilson has moved from a two-bedroom $650 apartment to a condo costing $1.100 per month. The association owns two golf courses, a lake and an activities center. His other monthly expenses include: Renter's Insurance Car payment Utilities Cell phone House phone Food Clothes $25 550 235 200 50 225 125 260 Car Expenses Entertainment 350 Wilson is surprised how much he spends on clothing and entertainment. He uses credit cards...the balance is $7,500 and climbing. Wilson makes the required monthly payments. He would like to reduce the balance and pay it off Wilson's other goal is to save for retirement by putting $4,500 per year away and retiring at 60. He wants to start saving in 5 years and does not think the delay will greatly affect the amount of retirement savings Wilson has a current balance in his checking account of $3,500 and $400 in his savings account. He has furniture valued at $1,800 and owns $1,500 of tech stocks, which he thinks, will grow by leaps and bounds. Case Questions-Section 1: la) Prepare a personal cash flow statement for Wilson Johnson Personal Cash Flow Statement (Monthly) Cash Inflows Cash Outflows 1b) Prepare a personal balance sheet for Wilson Liquid Assets Household Assets Investment Assets Liabilities & Net Worth Current Liabilities Long Term Liabilities Net Worth 2) Based on these statements, make specific recommendations to Wilson about what he needs to achieve his goals of paying off his credit card debt and saved for retirement 3) What additional goals could you recommend for Wilson in the short term and long term? 4a) Consider Wilson's goal to retire in 30 years by saving $4,500 per year starting 5 years from now. Based on your analysis, is this a realistic goal? If not, what would you advise? 4b) In order for Wilson to know what his investment will be worth in 30 years, what additional assumption or information does he need? 4c) Assuming Wilson can invest the $4,500 per year for 30 years starting 5 years from now and achieve an 8 percent return, how much will he accumulate in 25 years?
Expert Answer:
Answer rating: 100% (QA)
1a Cash Inflows Salary 3000 Rent 650 Utilities 235 Cell Phone 200 House Phone 50 Food 225 Clothes 125 Car Expenses 260 Entertainment 350 Total Cash In... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
The bookkeeper of Vital Inc. has asked you to assist him with the preparation of information about the companys trade receivables for presentation in the statement of financial position at December...
-
A local government agency has asked you to consult regarding acquisition of land for recreation needs for the urban area. The following data are provided: Urban population 10 years ago 49,050 Urban...
-
A midsized business with 100 end-users has asked you to develop a new intranet with a prioritizing requirement list. It is clear to you that the business cannot function without an intranet these...
-
You are given the following information: The current gold price is $1,650, the net convenience yield for gold is 1.7% per year, the risk-free rate is 5% per year, the volatility is 30% per year, the...
-
In August 2003, Tammy Duncan began working as a waitress at Bynum's Diner, which was owned by her mother, Hazel Bynum, and stepfather, Eddie Bynum. Tammy, Hazel, and Eddie signed an agreement stating...
-
Ryu Matsuya is looking for two investors to raise capital for a new venture company. Alston Capital is interested and so is Brennan Associates. He believes it is 80% likely that Alston will invest,...
-
The Miller Corporation issued \(\$ 100\) million maturity value of six percent coupon rate bonds, with interest paid semiannually. At the time of the bond issuance, equivalent risk-rated debt...
-
Popes Garage had the following accounts and amounts in its financial statements on December 31, 2010. Assume that all balance sheet items reflect account balances at December 31, 2010, and that all...
-
Problem 11-25 (Algo) Basic Transfer Pricing [LO11-3] Alpha and Beta are divisions within the same company. The managers of both divisions are evaluated based on their return on Investment (ROI)....
-
The Carolina Cougars is a major league baseball expansion team beginning its third year of operation. The team had losing records in each of its first 2 years and finished near the bottom of its...
-
What term means the distance from the bottom of the objective to the slide? explain 
-
Is there such a thing as universal human rights?
-
Suppose workers and firms suddenly believe that inflation will be quite high over the coming year. Suppose also that the economy begins in long-run equilibrium, and the AD curve does not shift. a....
-
Compare and contrast the Western impact on India and on China.
-
Compare and contrast the effects of colonialism on Latin America, Africa, and the Caribbean.
-
Are marriage patterns and social ties in agricultural states independent of economic and political considerations? If so, why? If not, what are some of the economic and political implications of...
-
Choosing the Optimal Product Mix with One Constrained Resource Billings Company produces two products, Product Reno and Product Tahoe. Each product goes through its own assembly and finishing...
-
Will the prediction interval always be wider than the estimation interval for the same value of the independent variable? Briefly explain.
-
Describe at least one norm (or collective assumption) and how it would affect a firm's perspective on creating an alliance.
-
1. What are the costs and benefits of FDI inflows for a host country such as Argentina? 2. Will foreign firms such as Repsol make decisions in the best interest of Argentina? 3. As a Spanish manager...
-
When does a majority JV seem more appropriate, and when is a minority JV more appealing?
-
A dishonest politician has four candidates for four patronage jobs. Each candidate has agreed to bribe the politician to obtain each job, by amounts shown in the matrix below (units of thousands of...
-
Show that the label changing algorithm must produce an equality subgraph that has a complete matching, by arguing as follows: (a) Upon changing labeling, since by claim (5) there is a new edge from...
-
A company is planning to locate five branches in five states. After studying various factors related to the local economies and tax laws of the states, the company has managed to quantify how...
Study smarter with the SolutionInn App