I. As of March 31, 2019 (the end of the prior quarter), the...

Thanks for your feedback!

Henry Corporation prepares its master budget on a quarterly basis. The following data have been assembled to assist in the preparation of the master budget for the second quarter of 2019: The company's gross profit rate is 40 percent of sales. Actual sales for March and budgeted sales for the next four months are as follows: March 2019: $170,000 April 2019: $200,000 May 2019: $250,000 June 2019: $190,000 July 2020: $150,000 Sales are 20 percent for cash and the rest on account. All sales on account are collected the month following sale. The accounts receivable on March 31 are a result of March credit sales. At the end of each month, inventory is to be on hand equal to 30 percent of the following month's sales needs, stated at cost. Thirty-five percent of a month's inventory purchases are paid for in the month of purchase; the rest is paid for in the following month. Monthly expenses are budgeted as follows: property taxes, $8,000 per month; salaries and wages, $18,000 per month; depreciation, $17,000 per month; advertising, 4 percent of sales; utilities, $12,000 per month; other expenses, 5 percent of sales. The company will declare and pay $20,000 in cash dividends per month. During April, the company will purchase a new computer for $12,000 in cash. During May, other equipment will be purchased for cash at a cost of $10,000. During June, another computer will be purchased for $12,000. As of March 31, 2019 (the end of the prior quarter), the company's general ledger showed the following account balances: Debits: Cash: $10,000 Accounts Receivable: $43,000 Inventory: $45,000 Plant and Equipment (net): $117,000 Credits: Accounts Payable: $46,000 Short-term Notes Payable: $15,000 Capital Stock: $95,000 Retained Earnings: $59,000 Total: $215,000 The company must maintain a minimum cash balance of $8,000. An open line of credit is available at a local bank for any borrowing that may be needed during the quarter. All borrowing is done at the beginning of a month, and all repayments are made at the end. Borrowings and repayments of principal must be in multiples of $1,000. Interest is paid at the end of each month. The interest rate is 12 percent per annum. (Figure interest in whole months, e.g., 1/12, 2/12.) Required: Prepare an interactive budgeting spreadsheet. It should automatically update when changes are made to the input data, such as changes in sales forecasts, equipment purchases, etc. Spreadsheet Hints: - Create a worksheet for inputs that includes all potential variables that can be changed. Label the worksheet tab as "inputs." - Create a worksheet for each of the different budgets. Label the tabs appropriately. The following budgets should be included: - Sales Budget - Inventory Purchases Budget - Selling and Administrative Budget - Cash Collections from Customers Schedule - Cash Paid for Inventory Purchases Schedule - Cash Budget - Budgeted Income Statement - Budgeted Balance Sheet Each budget should: - Be on a separate worksheet - Have a heading centered over the rest of the budget that includes the following: - Name of Company - Name of Budget - Date: "June 30, 2019" or "For the Quarter ended June 30, 2019" - Be prepared on a monthly basis with a total column for the quarter. The budgeted income statement and budgeted balance sheet should be quarterly (not monthly). All worksheets should be interactive (i.e. all worksheet pages except the Input worksheet should be formula-driven). We will use the following to grade the project: - You will lose 10 points if you do not have separate worksheets for each budget. - You will lose 15 points if the project is late. - You will lose up to 20 points if your worksheets are not interactive. - You will lose up to 20 points on the layout. - You will lose 15 points for not doing a cash budget. - You will lose 15 points for not doing a budgeted income statement. - You will lose 10 points for not balancing your budgeted balance sheet. - You will lose points based on accuracy also. Submit your file in Canvas. Label it using your last name followed by your first name. For example, my file would be named "terryglenn". Hints for Creating Interactive Cash Budget: - To calculate borrowings to the nearest thousands, you may use the ROUNDUP function. - To calculate repayments, you may use the ROUNDDOWN function.

Play audio

Feedback

QUESTION 1 Kasabrunu Enterprise is a business operating in the second-hand clothing in Kwadaso. Mr. Bruni the owner of Kasabrunu Enterprise (KE) employed Mr. Ojidomi a BSc. Accounting graduate as the Accountant. Business is booming and KE is expected to be in operation for a long time. Mr. Odjidomi has been with the business for 5 years and has assured Mr. Bruni that profits declared will not be deceptive since the same method will be continuously used for the accounting treatment of similar items until Mr. Bruni decides to change from dealing in second hand clothing to the purchase and sale of spare parts which they discussed. As part of the policy adopted by the business, the Accountant records only transactions that can be valued in monetary terms in the books of account and produces financial information at regular period for the perusal of Mr. Bruni. On reaching home, Sefakor Ojidomi, the daughter of Mr. Ojidomi who is pursuing an accounting programme in Owusuwusu College of Accountancy asked his father to guide her with an assignment. Sikadanka, the Chairman and CEO of Defenders Ltd recently confronted the Chief Accountant of the company over the way and manner the financial statements were presented for the 2019 financial year. The following points are summaries of the CEO’s reservations about the financial statements: He argued that the values of the company’s assets be shown at current market values since these values will provide a better view of the company’s value. The Chief Accountant is still insisting that the assets should be stated at original cost. He expressed shock when the financial statements did not show a value for the company’s efficient staff. He argued that the company’s beautiful and handsome sales personnel are valuable assets used to attract customers and therefore insisted that this “power of attraction” should be recognised in the books of accounts and reflected on the face of the financial statement. He was worried when a potential sale of millions of Ghana cedis to a certain buyer from whom purchase orders have been received have not been recognized in the books of accounts as sales. The Chief Accountant argued that these potential customers have only been sent pro-forma invoices and so are not obliged to pay the company. The CEO recently bought a saloon car for his son out of company funds. The Chief Accountant recorded this on a current account for the CEO. This resulted in an intense argument. The CEO threatened to dismiss the Chief Accountant should he refuse to recognize the purchase of the saloon car as a transaction of the company. The CEO insisted that the value of expired inventory should be maintained in the books of accounts and not written off. Sefakor presented the assignment and scored a 100% for the 1st time. On the 27th of March, 2019, Mr. Ogboro, the purchasing officer of KE prepared documents to purchase on credit 1,500 bales of second-hand clothing from Osimeyo and brothers (OB.). O.B delivered the goods to KE 4 (four) days after the order was placed with all appropriate documents. KE only deals in male second-hand clothing but included in the goods delivered were 15 bales of ladies second-hand clothing which Mr. Ogboro returned to OB as it did not meet the description provided. Customers purchased the goods either on credit or outright payment with cash or cheque. Documents showing evidence of payment were given to these customers. All customers who purchased on credit paid through their bankers by transfers made directly to the bank accounts of KE. KE is later advised accordingly by her bankers. Mr. Odjidomi prepares bank reconciliation statements quarterly. He made a request on the 15th of March 2019 for a bank statement from Obidibi commercial bank. Upon receipt of the bank statement, he compared the balance with that of the Cash book and it did not agree. The Accountant’s friend, Oyeni Bawabawat, an accounts officer at Oshikishiki Enterprise requested for reasons for the disagreement. He confessed his inability to grasp these reasons during his studies. After an in-depth explanation, Mr. Odjidomi, the Accountant asked his friend to assist him prepare a bank reconciliation statement as he had to urgently attend an important meeting. The Accountant provided his friend with the information below: The cash book, bank column of Kasabrunu Enterprise showed a credit balance of GHS578,000 while the bank statement for the period showed a debit balance of GH¢338,000 on 31st March,2019. A thorough investigation revealed the following: Cheques drawn amounting to GHS195,0000 had not been presented to the bank for payment. A cash deposit into the bank of GHS97,800 was recorded as GHS79,800 in the cash book. Bank charges of GHS10,900 and standing order payment of GHS12,100 relating to telephone bills entered on the bank statement had not been recorded in the cash book. A cheque of GHS245,000 drawn by the firm had been charged by the bank in error to another customer’s account. A dividend of GHS15,000 paid directly to the bank had not been entered in the cash book. A cheque for GHS20,000 paid into bank had been dishonoured and shown as such by the bank but no entry of the dishonour had been made in the cash book. The following cheques and cash deposits entered in the cash book and paid to the bank have not been credited by the bank: cash deposits GHS76,500; cheques receipts: Maame Dakona GH¢54,500; Ntekuma Ananse GHS34,000. A cheque drawn for GHS32,000 had been entered in the cash book in the error GHS23,000. A cheque for GHS16,000 drawn by another customer of the same name had been charged to the firm’s bank account in error. After adjusting the cash book balance, Oyeni Bawabawat prepared the bank reconciliation statement. After waiting for 3 hours, he was informed that Mr. Odjidomi will be in the meeting for 6 hours. Oyeni then left for his office. Required: A i) Identify and explain two (2) accounting policies adopted by Kasabrunu Enterprise (1mark) ii) State the accounting concept in each of the CEO’s reservation in Sefakor’s assignment. Explain your reason for choosing the concept. NB: Present your answer in a tabular form as illustrated below Concept/Principle | Definition/Explanation | Reason (5 marks) B. Identify and explain the use of three (3) source documents in the transaction to purchase and sell 1,500 bales of second-hand clothing. (4.5 marks) C. i) State and explain six (6) reasons Mr. Odjidomi will give to his friend for the disagreement in the cash book and bank statement balances. (3 marks) ii) Imagine you are Oyeni Bawabawat. Show the appropriate adjustments to be made in the cash book (4.5 marks) Prepare a Bank Reconciliation Statement for Mr. Odjidomi. (2 marks) (Total 20 marks) QUESTION 2 Halibatu, a sole trader, deals in phones and computer accessories at the Ohiamankwa Enterprise. The following Trial Balance was extracted from her books at 31st December, 2019 DR. GHS’000 | CR. GHS’000 Drawings & Capital: 2,128 | 18,043 Receivables & Payables: 7,689 | 5,462 Purchases & Sales: 62,101 | 122,242 Rent & Rates: 900 Gas &Electricity: 246 Carriage: 200 Salaries & Wages: 8,268 Bad debts: 247 Allowance for receivables: 326 Inventory (1/1/2019): 9,274 Insurance: 172 Discounts: 150 | 350 Advertising: 933 Cash at bank & on hand: 2,142 Investment in 91-Day Treasury Bills: 740 Interest on investment received: 56 Motor Vans at cost: 16,000 Computers (cost GH¢5million): 3,600 Provision for depreciation: Motor Vans | 8,600 Motor Expenses: 861 Returns: 232 | 54 Rent received: 750 Freehold premises at cost: 40,000 Totals: 155,883 | 155,883 Additional information: a) Inventory as at 31st December, 2019 was GHS 9,884,000 b) Rent & Rates paid covered the period 1st January, 2019 to 31st March, 2020. c) Some tenants have not yet paid their rent to Ohiamankwa Enterprise. The amount involved was GHS 250,000. d) Electricity bill of GHS 85,000 for December, 2019 has just been received. Halibatu intends to pay within the third week of January, 2020. No record has been made in the books. e) GHS 80,000 out of total carriage of GHS 200,000 relates to carriage on purchases made f) Allowance for receivables is adjusted to 5% of total receivables at the end of the year. g) An amount of GHS 202,000 was spent on the personal vehicle of Halibatu. This was included in the motor expenses. h) Depreciation is to be charged on vans at annual rate of 20% on cost. Computers are to be depreciated at the rate of 25% using the reducing balance method. You are required to prepare: i) Income statement for the year ended 31st December, 2019 ii) Statement of financial position as at 31st December, 2019 (Total 20 marks) QUESTION 3 A The agreement of the trial balance totals is an indication that all transactions have been properly recorded in the books of accounts. Do you agree with this statement? Required: Outline 4 reasons to justify your response. (8 marks) B ABC Ltd started business on 1/1/14, and its financial year ends on 31st December each year. The following information was extracted from the company’s asset register. DATE | TRANSACTION | AMOUNT (GHS) 2016 January, 1 | Purchased one motor van | 58,500 2016 September, 1 | Purchased two motor vans | 78,000 each 2018 March, 1 | Purchased one motor van | 45,200 2018 May, 2 | Sold the motor van purchased in January,2016 | 18,240 2019 April 1 | Purchased three motor vans | 62,000 each Additional Information The company’s policy is to depreciate Motor vehicles at a rate of 20% per annum on cost. You are required to prepare: i) The Motor vehicles account (2016-2019) ii) Provision for depreciation account (2016-2019) iii) Disposal account for 2018 iv) Statement of profit or loss extract for 2018 and 2019 v) Statement of financial position extract for 2018 and 2019 (12 marks) (Total 20 marks)

Sri K.

Question

Please give Ace some feedback