Prepare a monthly cash flow statement for samantha

Assignment Help Financial Accounting
Reference no: EM132962663

Planning for Multiple Goals

Samantha is a 36-year-old single mother to a five-year-old girl, Eve. Samantha is currently renting a condominium in British Columbia and would like to buy a house worth $400,000 in five years using an $80,000 down payment. She would also like to accumulate suf?cient funds to pay for four years of secondary education for Eve, at an expected cost of $15,000 (in today's dollars) at the start of each year over four years starting in 12 years. Finally, she plans to retire at age 65, at which time she plans to begin collecting her government and employment pensions which will meet her annual gross income retirement needs of $60,000 (in today's dollars).

Samantha earns a gross annual salary of $100,000 working in the head office of a financial institution. In addition to the government source deductions she pays, she also pays $200 per month in employment source deductions for her group insurance plan.

Samantha has the following investment assets:

  • $5,000 in her chequing account to cover her monthly expenses.
  • $8,000 cash in a savings account that earns 0.05% per year.
  • $30,000 cash in her Tax-Free Savings Account (TFSA) that earns 1.00% per year.

Samantha's car that is valued at $10,000 has an outstanding car loan secured against it with a balance owing of $8,000 at an interest rate of 7% (compounded monthly). She currently pays $240 per month towards the loan. She also has access to an unsecured line of credit that charges interest at 5% (compounded monthly). She has not borrowed any of the $30,000 credit limit that is available to her. Noreen also has a credit card with a limit of $10,000 and an interest rate of 20% (compounded monthly), however she pays it off every month so she has no balance currently owing.

Samantha's monthly housing expenses include $2,000 in rent, $300 for her condominium fee, $100 each for heat, electricity and water, and $50 for renter's insurance. Her monthly transportation costs include $100 each for insurance, maintenance and gas, as well as $120 for her transit pass. Samantha and Eve's lifestyle expenses include $800 for food, $70 for a cell phone, $150 for TV, cable and a home phone, $200 per month on entertainment (mostly on events that she and Eve attend together), and $400 for Eve's extra-curricular activities, including swimming lessons and dance classes.

Problem 1. Identify and write down Samantha's goals.

Problem 2. Prepare a net worth statement for Samantha.

Problem 3. Prepare a monthly cash flow statement for Samantha.

Problem 4. How much free cash flow does Samantha have each month?

Problem 5. Does Noreen have a cash surplus or deficit?

Problem 6. How large should Samantha's emergency reserves be based on her monthly expenses? Does she have sufficient emergency reserves to cover her in the event of an emergency?

Problem 7. What recommendation could you make to help Samantha improve her financial situation? How would your recommendation affect her net worth and free cash flow?

Problem 8. What should Samantha do with her free cash flow?

Reference no: EM132962663

Questions Cloud

What exchange ratio would make the merger terms equivalent : Suppose Birdie is unwilling to pay cash for merger, What exchange ratio would make merger terms equivalent to the original merger price of $68.75 per share?
Prepare the september entry to establish the fund : The company uses the perpetual system in accounting for merchandise inventory. Prepare (1) the September 9 entry to establish the fund
What is the premium or discount and the purchase price : A $290,000 issue of five-year bonds redeemable, What is the premium or discount and the purchase price of the bonds to yield 9% compounded quarterly?
Provide the journal entries under the trade date accounting : Provide the journal entries under the trade date accounting and the settlement date accounting assuming the financial asset purchased
Prepare a monthly cash flow statement for samantha : Prepare a monthly cash flow statement for Samantha. Samantha earns a gross annual salary of $100,000 working in the head office of a financial institution.
How much will need to save every month to fund : How much will they need to save every month to fund their retirement needs if they do not currently have any investments earmarked for retirement?
What is the direct materials quantity variance : During December 2020, Robin's Ribbons sells 200 giant bows. What is the Direct Materials Quantity Variance
How much free cash flow do jasper and anneka have each month : The couple's lifestyle expenses include $1,000 for food, $150 for their cell phones, How much free cash flow do Jasper and Anneka have each month?
Determine juice variable overhead efficiency variance : During the month employees worked an average of 4 000 hours at an average rate of R2,50 per hour. Determine Juice variable overhead efficiency variance

Reviews

Write a Review

Financial Accounting Questions & Answers

  What is the value of the endowment

If the interest rate is 10% what is the value of the endowment? A wealthy investor endows a scholarship fund at the local university that would pay $15,000.

  At what level of stocks should the firm reorder

If the restaurant requires a safety stock of 100 boxes and the supplier need a 10-day delivery time, at what level of stocks should the firm reorder

  Prepare a statement of cash flows in accordance with aasb

Using the direct method of presenting cash flows from operating activities, prepare a Statement of Cash Flows in accordance with AASB 107 for the year ended 30 June 2012, including a reconciliation of cash flows arising from operating activities a..

  Melanie is the head of two different departments in the

melanie is the head of two different departments in the similar company. the toys department is doing very well but the

  What is the compound annual rate implied

You can borrow $800 today and repay $850 in two weeks. What is the compound annual rate implied by this 15 percent rate charged for only two weeks?

  Estimate the value of IDX per share

Estimate the value of IDX per share using a discounted Free Cash Flow (FCF) approach and the following data: -Debt: $70 million

  Why is understanding the concept of interperiod equity

Why is understanding and applying the concept of "interperiod equity" necessary in planning your organization's budget and its actual implementation?

  Compute the amount of gross profit to be recognized

Compute the amount of gross profit to be recognized in each of the three years. (Leave no cells blank - be certain to enter "0" wherever required. Omit the "$" sign in your response.)

  Determine the issue price of the bonds

On June 1, 2014, Mink Company issued $12,000,000 of 10 percent bonds to yield 12 percent. Interest is payable semiannually on May 31 and November 30. The bonds mature in 15 years. Mink Company is a calendar-year corporation. Determine the issue price..

  What are the advantages of the residual policy

What are the advantages and disadvantages of the residual policy? In general terms, how would a change in investment opportunities affect the payout ratio

  Post the transaction from journal to ledger

Journalized the transaction? Post the transaction from journal to ledger? Produce un adjusted trial balance? Adjusting entries on Hamle 30,2011?

  Which one of the following is created

When employers retroactively amend pension plans to increase benefits to participants, which one of the following is created? Prior service cost

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd