Lindor Enterprises projects sales for the first three months of the year to be: $10,400 in January, $12,500 in February, and $13,100 in March. Cash receipts are expected to be: $8,580 in January, $11,820 in February, and $12,700 in March. They anticipate the following cash payments: Lindor Enterprises January February March Direct materials purchased $3,600 $4,200 $4,700 Direct labor costs $3,300 $4,000 $3,500 Depreciation on plant $570 $570 $570 Utilities for plant $650 $650 $650 Property taxes on plant $170 $170 $170 Depreciation on office $580 $580 $580 Utilities for office $350 $350 $350 Property taxes on office $180 $180 $180 Office salaries $3,000 $3,000 $3,000   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 $900 and repays the amounts borrowed in increments of $900 at the beginning of months when excess cash is available. The interest rate on borrowed amounts is 5% per year. Interest is paid at the beginning of the month on the outstanding balance from the previous month. Complete a Cash Budget for Lindor Enterprises. 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 overhead         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         Ending cash balance

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question
Lindor Enterprises projects sales for the first three months of the year to be: $10,400 in January, $12,500 in February, and $13,100 in March. Cash receipts are expected to be: $8,580 in January, $11,820 in February, and $12,700 in March.

They anticipate the following cash payments:

Lindor Enterprises January February March
Direct materials purchased $3,600 $4,200 $4,700
Direct labor costs $3,300 $4,000 $3,500
Depreciation on plant $570 $570 $570
Utilities for plant $650 $650 $650
Property taxes on plant $170 $170 $170
Depreciation on office $580 $580 $580
Utilities for office $350 $350 $350
Property taxes on office $180 $180 $180
Office salaries $3,000 $3,000 $3,000

 

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 $900 and repays the amounts borrowed in increments of $900 at the beginning of months when excess cash is available. The interest rate on borrowed amounts is 5% per year. Interest is paid at the beginning of the month on the outstanding balance from the previous month.

Complete a Cash Budget for Lindor Enterprises.

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 overhead        
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        
Ending cash balance        
 
Expert Solution
steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education