Prepare the family projected cash budget

Assignment Help Managerial Accounting
Reference no: EM132579545

Point 1: Peter Stress is the Information Systems Manager at Technotronics Company, a position that he has held for the last 10 years on a full time and pensionable basis. He is on a monthly gross salary of ksh 300,000 but takes home ksh 240,000 after all statutory deductions. He is engaged in other part time activities like installing networking cables and anti-virus programs for business bureaus and internet cafes on Saturdays only but reserves Sundays for prayers since he is a devoted Christian.

Point 2: Some of his clients need his services on Sunday but he refuses flatly despite the fact that the bureaus open throughout the week. He gets an average of ksh.50,000 per month from these part time activities. He has been married to Julia for ten years and they have two children Ben aged 10 and Ann aged 7 who are in class five and two respectively in a private academy within the estate. Julia is a primary school teacher in a public school within the estate and earns a net salary of 50,000 pm of which she contributes 5,000 per month to a 10 Ladies "Merry Go Round Scheme".

Point 3: She joined Merry Go Round wef from 1st December 2019 and is due to receive her share of ksh.50,000 in ten months' time as she is the last in the queue. She supplements their monthly shopping by ksh.10,000 per month. Julia's personal grooming is ksh.15,000 pm. He does not know the breakdown of her other expenses as she does not disclose them to him and he is not sure whether he should ask her.

Point 4: Peter invested shares worth ksh, 200,000 in Xer company in November 2018 and expects a cash dividend of Ksh.32,000 after withholding tax in March 2020. He also expects dividends of ksh 48,000 (net) from Mar Sacco being a return on his Sacco shares in February 2020.

Point 5: His average monthly expenses are as follows Rent ksh.45,000(a three-bedroomed apartment in the Donholm Estate, 18 kilometres from the Nairobi city centre and a walking distance from Gwen school); Electricity ksh.10,000pm ; Food ksh 35,000 pm: Water 5,000 pm; Fuel /Transport ksh 35,000 pm, Medical expenses ksh20,000 pm; School fees due in January ksh 110,000, May ksh 110,000 and September ksh 110,000; Telephone 20,000 pm; entertainment ksh. 35,000 pm; Miscellaneous ksh 20,000 pm; Bank charges ksh.2,500 pm; Estate Security fees ksh. 6,000 pm and Welfare ksh.2,000 pm. Clothing ksh.30,000 pm; House help ksh.8,000 pm; He is due to pay dowry of ksh. 250,000 in March 2020 that he has been postponing for the last 10 years.

Point 6: He is also being deducted a Sacco loan ksh. 100,000 per month. This loan will be over in December 2020. Minimum bank balance ksh.2,000. He went to SIBIA bank on 22th December 2019 and approached the customer consultant for the possibilities of getting a short term unsecured loan to help him meet his financial obligations. Miss Mandeke, the customer consultant told him that he needs to prepare cash budget for January to December 2020 in order to determine the amount he can borrow. The bank is willing to grant him a loan payable within 12 months at simple interest rate of 15% per annum with a grace period of 1 month if he qualifies.

Point 7: Peter stress has approached you on 28th December 2019 to assist him as he is unsure of how much to borrow and when to borrow that amount. He has also sought your help in managing his financial crisis. His bank balance was to be ksh.30,000 on 31nd December 2019

Required

Question (i) Prepare the family's projected cash budget (fully linked) for January to December 2020

Question (ii) Give 6 suggestions on how he can increase the income of the family.

Question (iii) Give at least 6 suggestions on each budget item to help reduce or manage their expenses .)

Question (iv) Advise him on at least 6 strategies that they can adopt to manage better the family's personal finances.

Reference no: EM132579545

Questions Cloud

Write a security plan proposal : Write a Security Plan Proposal as a project draft document with the formats in the bullet points below. Please note that the project document
What need to report on benefits create higher profit margin : What would need in order to report on the benefits and problems for creating higher profit margin on the basis of the design manager's proposals
Compute amount of Ocean City Kite Company fixed costs : Ocean City Kite Company manufactures & sells kites for $7.00 each. Compute amount of Ocean City Kite Company fixed costs
What are margin of safety amounts of unilever company : What are the fixed costs, variable costs, sales per unit, contribution per unit and margin of safety amounts of Unilever company. Provide the suitable example.
Prepare the family projected cash budget : Prepare the family's projected cash budget (fully linked) for January to December 2020. Peter Stress is the Information Systems Manager
Calculate the pounds of material to be purchased : Each unit requires 5 pounds of material which costs $3.00 per pound. Calculate the pounds of material to be purchased
Compute the cash payback period and net present value : Bramble Corporation is considering purchasing a new delivery truck. Compute the cash payback period and net present value of the proposed investment
Prepare income statement according to the absorption costing : Prepare income statement according to the absorption costing concept. Income Statements under Absorption and Variable Costing Shawnee Motors Inc
How would Tesco account for these transactions : How would Tesco account for these transactions for its fiscal report ending on February 21 and on August 23, 2014

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Manage budgets and financial plans

Explain the budgeting process and its importance to a business, identifying the components of different budgets, forecast estimates for inclusion in the budgets.

  Prepare a retained earnings statement

Prepare a retained earnings statement for the year and Prepare a stockholders' equity section of given case.

  Prepare a master budget for the three-month period

Prepare a master budget for the three-month period.

  Construct the companys direct labor budget

Construct the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced.

  Evaluate the predetermined overhead rate

Evaluate the Predetermined Overhead Rate

  Determine the company''s bid

Determine the company's bid if activity-based costing is used and the bid is based upon full manufacturing cost plus 30 percent.

  Compute the pool rates for the different activities

Complete the schedule to compute the pool rates for the different activities.

  Prepare Company financial statements

Prepare Company financial statements

  Prepare an analysis of terracycles

This individual assignment is based on the TerraCycle Inc.

  Discuss the ethical issues

Discuss the ethical issues

  Political resources in emerging markets

Calculate the GDP in Income Approach  and Expenditure Approach

  Management accounting - ehsan electronics company

A new plant accountant suggested that the company may be able to assign support costs to products more accurately by using an activity based costing system that relies on a separate rate for each manufacturing activity that causes support costs.

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