Complete a Cash Budget for Lindor Enterprises.
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Lindor Enterprises projects sales for the first three months of the year to be: $10,100 in January, $12,400 in February, and $12,900 in March. Cash receipts are expected to be: $8,450 in January, $11,770 in February, and $12,810 in March.
They anticipate the following cash payments:
Also, Lindor Enterprises beginning cash balance is $3,100 and they desire to maintain a minimum ending cash balance of $3,100. Lindor Enterprises borrows cash as needed at the beginning of each month in increments of $1,000 and repays the amounts borrowed in increments of $1,000 at the beginning of months when excess cash is available. The interest rate on borrowed amounts is 7% per year. Interest is paid at the beginning of the month on the outstanding balance from the previous month.
Complete aCash Budget for Lindor Enterprises.
Lindor EnterprisesCash BudgetFor the Quarter Ending March 31
They anticipate the following cash payments:
Lindor Enterprises | January | February | March |
---|---|---|---|
Direct materials purchased | $3,500 | $4,000 | $4,900 |
Direct labor costs | $3,000 | $4,100 | $3,600 |
$510 | $510 | $510 | |
Utilities for plant | $650 | $650 | $650 |
Property taxes on plant | $140 | $140 | $140 |
Depreciation on office | $560 | $560 | $560 |
Utilities for office | $370 | $370 | $370 |
Property taxes on office | $170 | $170 | $170 |
Office salaries | $2,900 | $2,900 | $2,900 |
All costs are paid in the month incurred except: direct materials, which are paid in the month following the purchase; utilities, which are paid in the month after incurred; and property taxes, which are prepaid for the year on January 2. The Accounts Payable and Utilities Payable accounts have a zero balance on January 1.
Also, Lindor Enterprises beginning cash balance is $3,100 and they desire to maintain a minimum ending cash balance of $3,100. Lindor Enterprises borrows cash as needed at the beginning of each month in increments of $1,000 and repays the amounts borrowed in increments of $1,000 at the beginning of months when excess cash is available. The interest rate on borrowed amounts is 7% per year. Interest is paid at the beginning of the month on the outstanding balance from the previous month.
Complete a
Lindor EnterprisesCash BudgetFor the Quarter Ending March 31
January | February | March | Total | |
---|---|---|---|---|
Beginning cash balance | ||||
Cash receipts | ||||
Cash available | ||||
Cash payments: | ||||
Purchases of direct materials | ||||
Direct labor | ||||
Manufacturing |
||||
Selling and administrative expenses | ||||
Interest expense | ||||
Total cash payments | ||||
Ending cash balance before financing | ||||
Minimum cash balance desired | ||||
Projected cash excess (deficiency) | ||||
Financing: | ||||
Borrowing | ||||
Principal repayments | ||||
Total effects of financing | ||||
Single lineEnding cash balance |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 2 images
Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education