Individual Assignment 1 FINA

docx

School

Sheridan College *

*We aren’t endorsed by this school

Course

55142

Subject

Accounting

Date

Apr 3, 2024

Type

docx

Pages

6

Uploaded by SuperHumanViper4186

Report
Applied Financial Analysis Individual Assignment 1 (10%) Minden Company is a wholesale distributor of premium European chocolates. Name – Karan Kapur Student Number - 991758554
Question Assets Amount ($) Cash $9,000 Accounts receivable, customers $54,000 Inventory $30,000 Buildings and equipment (net of depreciation) $207,000 Total assets $300,000 Liabilities and Shareholders’ Equity Amount ($) Accounts payable, suppliers $63,000 Note payable $14,500 Capital shares, no par $180,000 Retained earnings $42,500 Total liabilities and shareholders’ equity $300,000 Adjustments: - The company is in the process of preparing budget data for May. A number of budget items have already been prepared, as follows: a. Sales are budgeted at $200,000 for May. Of these sales, $60,000 will be for cash; the remainder will be credit sales. One-half of a month's credit sales are collected in the month the sales are made, and the remainder are collected in the following month. All of the April 30 receivables will be collected in May.
b. Purchases of inventory are expected to total $120,000 during May. These purchases will all be on account. 40% of all purchases are paid for in the month of purchase; the remainder are paid in the following month. All of the April 30 accounts payable to suppliers will be paid during May. c. The May 31 inventory balance is budgeted at $40,000. d. Operating expenses for May are budgeted at $72,000, exclusive of depreciation. These expenses will be paid in cash. Depreciation is budgeted at $2,000 for the month. e. The note payable on the April 30 balance sheet will be paid during May, with $100 in interest. (All of the interest relates to May.) f. New refrigerating equipment costing $6,500 will be purchased for cash during May. 8. During May, the company will borrow $20,000 from its bank by giving a new note payable to the bank for that amount. The new note will be due in one year. Questions: 1. Prepare a cash budget for May. Support your budget with schedules showing budgeted cash receipts from sales and budgeted cash payments for inventory purchases. 2. Prepare a budgeted income statement for May. Use the traditional income statement format. 3. Prepare a budgeted balance sheet as of May 31.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Answer 1: Answer 2:
Answer 3: Notes:
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help