Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

B. Budgeting (30 points) Narda Corporation's actual sales and purchases for April are shown here along with forecasted sales and purchases for June through September:

image text in transcribed
B. Budgeting (30 points) Narda Corporation's actual sales and purchases for April are shown here along with forecasted sales and purchases for June through September: Sales(Pesos) Purchases (Pesos) April (Actual) 640,000 260,000 May (Actual) 600,000 240,000 June (Forecast) 550,000 240,000 July (Forecast) 550,000 360,000 August (Forecast) 580,000 400,000 September (Forecast) 660,000 340,000 The company makes 10% of its sales on cash and 90% on credit. Of the credit sales, 20% are collected in the month after the sales and 80% are collected two months after. The company pays 40% of its purchases in the month after purchase and 60% two months after. Labor expense equals 10% of the current month's sales. Overhead expense equals P24,000 per month. Interest payments of P60,000 are due in June and September. A cash dividend of P100,000 is scheduled to be paid in June. Taxes of P50,000 are due in June and September. There is a scheduled capital outlay of P600,000 in September. The company's ending cash balance in May is P40,000. The minimum desired cash balance is P30,000. Prepare a schedule of monthly cash receipts, monthly cash payments, and a complete monthly cash budget with borrowing and repayments for June to September. The maximum desired cash balance is P100,000. Excess cash (above P100,000) is used to buy Trading Securities. Trading Securities are sold prior to borrowing funds in case of a cash shortfall (less than P30,000)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Horngrens Financial & Managerial Accounting The Financial Chapters

Authors: Tracie L. Miller Nobles, Brenda L. Mattison, Ella Mae Matsumura

4th Edition

0133255573, 978-0133255577

More Books

Students also viewed these Accounting questions

Question

Describe effectiveness of reading at night?

Answered: 1 week ago

Question

find all matrices A (a) A = 13 (b) A + A = 213

Answered: 1 week ago

Question

2. Information that comes most readily to mind (availability).

Answered: 1 week ago

Question

3. An initial value (anchoring).

Answered: 1 week ago