Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

a. A profit and loss budget for the 6 months ending 31/12/2018. b. A balance sheet budget as at 31/12/2018 c. A cash flow budget

a. A profit and loss budget for the 6 months ending 31/12/2018.

b. A balance sheet budget as at 31/12/2018

c. A cash flow budget for the 6 months ending 31/12/2018.

d. As a Board of Director Member would you approve to fund the project. Why?


The management board of an organization want to start a project that can generate income in order to get a better financial position and better  quality of services it is rendering to the community. The Board of Directors asked you to help in sitting an operating budget including a cash budget for the six months ending 31/12/2018. The Board of Directors has promised to secure $100,000 for this project if it proves to be profitable.

Their accountant gathered theses data:

  • $100,000 is expected to be secured by the Board of Directors and the project will start on 1/7/2018.
  • A building will be rented at an annual rent fee of $24,000. It is expected that the rent of the first three months will be paid in advance.
  • Equipment will be purchased for $79,200. 50% will be paid at the time of purchase i.e. in July 2018 and 50% in October 2018. The estimated useful life of this equipment is 4 years.
  • It is expected that utilities will be $5,000 per quarter payable at the beginning of the following quarter.
  • Furniture will be purchased for $4,080 in July 2018. The estimated useful life of this equipment is 2 years.
  • A vehicle will be purchased for $8,160 in July 2018. Annual insurance is $1,500 payable in July 2018. The estimated useful life of the vehicle is 4 years.
  • It is estimated that raw materials usage will average $25,000 monthly. It is also estimated that purchases of raw materials will be $50,000 in July 2018, $60,000 in September 2018, and $60,000 in November 2018.
  • It is expected that the payment of supplies will be made in the month following the purchase.
  • Salaries are expected to be $2,000/month for the first quarter and $3,000 per month for the second quarter.  
  • Other operating expenses are estimated at $2,500 per month.
  • Market analysis showed the following sales estimates. Sales will be on credit with collections after 2 months of sales.

July 16
Aug 16
Sept 16
Oct 16
Nov 16
Dec 16
Estimated Sales in $
0
20,000
30,000
50,000
100,000
100,000



Step by Step Solution

3.45 Rating (152 Votes )

There are 3 Steps involved in it

Step: 1

D The project shows a good Net return on Investment for the period So as a board of director members ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting for Governmental and Nonprofit Entities

Authors: Earl R. Wilson, Jacqueline L Reck, Susan C Kattelus

16th Edition

78110939, 978-0078110931

More Books

Students also viewed these Accounting questions