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

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

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