Question

Financial budget Capital expenditures budget • Cash budget • Pro-forma balance sheet at December 31, 2019 • Pro-forma stateme

The rest of the details:

Gadgets, Inc. is incorporated and will begin operations on January 1, 2019. Its primary business is the manufacture and sale of gadgets. Because cash resources are limited, the company anticipates the need to have access to capital during the first year of operations and seeks to establish a line of credit with a local bank. The bank requires a complete operating and cash budget and pro-forma financial statements for 2019 as part of the loan application. The following information and data are to be used in preparing the budget.

1) Gadgets, Inc. is a closely-held corporation. The original owners have invested an initial $150,000 (assume the initial cash funding occurs on January 1, 2019) to establish the corporation and are the only shareholders of the company.

2) Production equipment totaling $36,000 will be purchased on January 2, 2019 and put into immediate use. The equipment has an expected useful life of five years, with no salvage value. It will be depreciated using straight-line depreciation method.

3) The sole product is the Standard Gadget. Each unit requires four pounds of raw material. The cost of the raw material is $0.50 per pound. It takes six minutes of direct labor to produce one gadget. Direct labor employees are paid $15.00 per hour.

4) Monthly fixed and variable overhead and selling & administrative (S&A) expenses are estimated below. Fixed manufacturing overhead is allocated on the basis of direct labor hours. VARIABLE FIXED Manufacturing overhead (including depreciation) 30% of direct labor costs $20,000 Selling & Administrative Expenses $0.30 per unit sold $ 6,000

5) Gadgets will sell for $8.00 each. January sales are expected to be 8,000 units. Demand is expected to increase by 400 units per month until a level of 12,000 units per month is reached.

6) Gadgets, Inc.’s inventory policy establishes the following required monthly ending inventory levels: • Finished Goods: Maintain an ending inventory equal to one-half of the following month's expected sales. • Raw Materials: Maintain an ending inventory quantity equal to three-fourths of the materials needed for the next month's production. • Work-in-Process: Assume the month-end inventory is zero.

7) All sales are made to established credit customers with credit terms of net 90 days. No 3 sales discounts are offered for early payment. Twenty percent (20%) of payments for credit sales are expected to be received in the first month subsequent to the month of sale. Another sixty percent (60%) of payments are expected to be received in the second month after the sale. The remaining twenty percent (20%) of payments are expected to be received in the third month subsequent to the sale. (As an example, if January sales are $10,000, the company expects to receive payments of $2,000, $6,000 and $2,000 in February, March and April, respectively.)

8) Gadgets, Inc. has a credit arrangement with its raw materials vendor and purchases all materials on account with a basic invoice term of net 60 days. The company receives NO cash discounts for early payment of invoices. One-half of raw material purchases will be paid in the month of purchase. The remaining one-half will be paid in the first month subsequent to the purchase.

9) All other operating expenses will be paid in the month incurred.

10) The income tax rate is 24%. Estimated tax payments are made to the US Treasury on the last day of each quarter. Each quarterly payment is $5,000. Any balance due at year-end is recorded as a liability on the balance sheet. If taxes have been overpaid, the estimated refund is recorded as a receivable on the balance sheet.

11) The company requires a minimum ending monthly cash balance of $2,000 which must be reflected in the cash budget.

12) The proposed funding agreement with the bank is a line of credit of up to $100,000, effective January 1, 2019. The annual interest rate on the line of credit is 4%, payable on the last day of each month on the outstanding loan balance.

More info:

In any month that the cash budget indicates ending monthly cash balance less than the required minimum cash balance; the company will borrow against the line of credit an amount sufficient to bring the ending cash balance up to the required $2,000 minimum. If the ending monthly cash balance is greater than the $2,000 required minimum, the excess cash will be used to repay the outstanding balance. Borrowings and repayments throughout the year will be budgeted in increments of $100. However, the company will budget for a final December payment that will reduce the line of credit balance to zero. Borrowing and repayments will occur on the last day of the month (not affecting the month end calculation of interest payment due that day.

Conditions: In calculating the month-end amount to borrow, it must be an amount sufficient to cover any cash deficit plus any amount due as interest for that month. Every month must end with a cash balance above the $2,000 minimum.

b) Repayments: Loan repayments are budgeted to be paid only if (1) there is a cash surplus at the end of the month, (2) the amount of the cash surplus exceeds any interest due that month, and (3) there is any balance due on the loan. The cash surplus must first be used to pay interest due, and then any remaining surplus can be used for repayment of the loan principal.

c) Loan Balance: Include a line in the cash budget to calculate the running principal balance of the line of credit. The loan balance at the end of any month is equal to the loan balance at the end of the previous month, plus any new borrowing in the current month, or minus any repayment in the current month.

d) Interest Payments: All borrowing and repayments take place on the last day of the month. Therefore, any interest to be paid in the current month is based on the loan balance at the end of the previous month.

e) Ending Cash Balance: The ending cash balance for each month is total cash receipts, minus total cash expenditures, plus the amount of net financing.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Here are different schedules of Gadget Inc for 12 month period ending December 31, 2019:

Operating Budget of Gadget Inc for 12-month period ending December 31, 2019
Description Ref Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Revenue in units              8,000              8,400              8,800              9,200              9,600           10,000           10,400           10,800           11,200           11,600           12,000           12,000
Sales in $ A           64,000           67,200           70,400           73,600           76,800           80,000           83,200           86,400           89,600           92,800           96,000           96,000     976,000
Direct Material in pound (4 pounds per unit)           32,000           33,600           35,200           36,800           38,400           40,000           41,600           43,200           44,800           46,400           48,000           48,000
Direct Material in $ ($0.5 per pound) B           16,000           16,800           17,600           18,400           19,200           20,000           20,800           21,600           22,400           23,200           24,000           24,000     244,000
Direct Labour in hrs (6 minutes per unit)                 800                 840                 880                 920                 960              1,000              1,040              1,080              1,120              1,160              1,200              1,200
Direct Labour in ($15 per hr) C           12,000           12,600           13,200           13,800           14,400           15,000           15,600           16,200           16,800           17,400           18,000           18,000     183,000
Variable OH
Variable Manufacturing OH (30% of direct labor cost) D              3,600              3,780              3,960              4,140              4,320              4,500              4,680              4,860              5,040              5,220              5,400              5,400        54,900
Variable Selling & Administrative OH ($0.30 per unit sold) E              2,400              2,520              2,640              2,760              2,880              3,000              3,120              3,240              3,360              3,480              3,600              3,600        36,600
Contribution Margin F = A-(B+C+D+E)           30,000           31,500           33,000           34,500           36,000           37,500           39,000           40,500           42,000           43,500           45,000           45,000     457,500
Fixed OH
Fixed Manufactuing OH (Excl Deprn)           19,400           19,400           19,400           19,400           19,400           19,400           19,400           19,400           19,400           19,400           19,400           19,400     232,800
Fixed Selling & Administrative OH              6,000              6,000              6,000              6,000              6,000              6,000              6,000              6,000              6,000              6,000              6,000              6,000        72,000
Depreciation & Amortisation ($36000 for 5 years)                 600                 600                 600                 600                 600                 600                 600                 600                 600                 600                 600                 600          7,200
           Total Fixed OH G           26,000           26,000           26,000           26,000           26,000           26,000           26,000           26,000           26,000           26,000           26,000           26,000     312,000
Net Income F - G              4,000              5,500              7,000              8,500           10,000           11,500           13,000           14,500           16,000           17,500           19,000           19,000     145,500
Interest Exp (as per line of credit interest schedule below)              2,136              4,000              4,000              4,000              4,000              4,000              4,000              4,000              4,000              4,000              4,000              3,800        45,936
Net Income After Interest              1,864              1,500              3,000              4,500              6,000              7,500              9,000           10,500           12,000           13,500           15,000           15,200        99,564
Tax @ 24%                 447                 360                 720              1,080              1,440              1,800              2,160              2,520              2,880              3,240              3,600              3,648        23,895
Net Income After Tax              1,417              1,140              2,280              3,420              4,560              5,700              6,840              7,980              9,120           10,260           11,400           11,552        75,669
Add a comment
Know the answer?
Add Answer to:
The rest of the details: Gadgets, Inc. is incorporated and will begin operations on January 1, 2019. Its primary...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Kaiser, Inc. has the following budgeted cash collections from the cash receipts budget and cash payments...

    Kaiser, Inc. has the following budgeted cash collections from the cash receipts budget and cash payments (excluding loan principal repayments and interest payments) from the cash disbursements budget for the next quarter (April, May, & June). Cash Receipts Cash Payments April $30,024 $27,064 May $32,398 $39,383 June $36,064 $32,772 In addition, Kaiser's beginning cash balance as of April 1 is $15,290. Kaiser, Inc. would like to maintain a minimum $15,000 cash balance at all times. In order to achieve this...

  • Alderman Health Center provides a variety of medical services. The company is preparing its cash budget for t...

    Alderman Health Center provides a variety of medical services. The company is preparing its cash budget for the upcoming third quarter. The following transactions are expected to our (Click the icon to view the expected transactions.) Requirement Prepare a combined cash budget for Alderman Health Center for the third quarter, with a column for each month and for the quarter total (a box is not used in the table leave the box empty, do not enter a zero. Use parentheses...

  • MB 235 Spring 2019 Take-home portion of final Problem 1 (20 points) It is currently November 1, 2019 and Design Supply Corporation, a merchandising entity, is preparing a cash budget for the first tw...

    MB 235 Spring 2019 Take-home portion of final Problem 1 (20 points) It is currently November 1, 2019 and Design Supply Corporation, a merchandising entity, is preparing a cash budget for the first two months of 2020. The following data have been forecasted Sales 750,000 $00,000 Opcrating expenses 146,800167,400 52,700 62.00 8,750 23,750 23.750 Advertising Depreciation Cash 8,750 End of January balances: 120,000 480,000 Bank loan Additional data: (1) Sales are 40% cash and 60% credit each month. It is...

  • Sweeney Health Center provides a variety of medical services. The company is preparing its cash budget...

    Sweeney Health Center provides a variety of medical services. The company is preparing its cash budget for the upcoming third quarter. The following transactions are expected to occur: (Click the icon to view the expected transactions.) Requirement Prepare a combined cash budget for Sweeney Health Center for the third quarter, with a column for each month and for the quarter total. (If a box is not used in the table leave the box empty; do not enter a zero. Use...

  • Sesnie Health Center provides a variety of medical services. The company is preparing its cash budget...

    Sesnie Health Center provides a variety of medical services. The company is preparing its cash budget for the upcoming third quarter. The following transactions are expected to occur: (Click the icon to view the expected transactions.) Requirement Prepare a combined cash budget for Sesnie Health Center for the third quarter, with a column for each month and for the quarter total. (If a box is not used in the table leave the box empty; do not enter a zero. Use...

  • a. Prepare a schedule of monthly cash receipts for January, February, and March.    b. Prepare...

    a. Prepare a schedule of monthly cash receipts for January, February, and March.    b. Prepare a schedule of monthly cash payments for January, February, and March. c. Prepare a monthly cash budget with borrowings and repayments for January, February, and March. (Negative amounts should be indicated by a minus sign. Assume the January beginning loan balance is $0.) Harry's Carryout Stores has eight locations. The firm wishes to expand by two more stores and needs a bank loan to...

  • Ch 07 Ex 7-17 Saved Help Save According to a credit agreement with its bank, Kayak...

    Ch 07 Ex 7-17 Saved Help Save According to a credit agreement with its bank, Kayak requires a minimum cash balance of $40,000 at each month-end. In return, the bank has agreed that the company can borrow up to $140,000 at a monthly interest rate of 1%, paid on the last day of each month. The interest is computed based on the beginning balance of the loan for the month. The company repays loan principal with any cash in excess...

  • Monachino Health Center provides a variety of medical services. The company is preparing its cash budget...

    Monachino Health Center provides a variety of medical services. The company is preparing its cash budget for the upcoming third quarter. The following transactions are expected to our Click the icon to view the expected transactions.) Requirement Prepare a combined cash budget for Monachino Health Center for the third quarter, with a column for each month and for the quarter total (a box is not used in the table leave the box empty, do not enter a zero. Use parentheses...

  • Kayak Co. budgeted the following cash receipts (excluding dash receipts from loans received) and cash payments...

    Kayak Co. budgeted the following cash receipts (excluding dash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. Cash Receipts $525,000 400,eee 45e,eee Cash payments $475,eee 350, eee 525,e00 January February March According to a credit agreement with the company's bank, Kayak promises to have a minimum cash balance of $30,000 at each month-end. In return, the bank has agreed that the company can borrow...

  • Alderman Health Center provides a variety of medical services. The company is preparing its cash budget...

    Alderman Health Center provides a variety of medical services. The company is preparing its cash budget for the upcoming third quarter. The following transactions are expected to occur (Click the icon to view the expected transactions.) Requirement Prepare a combined cash budget for Alderman Health Center for the third quarter, with a column for each month and for the quarter total (a box is not used in the table leave the box empty, do not enter a zero Use parentheses...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT