Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Pavlova Instruments, a maker of precision telescopes needs a financial planning schedule for the months of October, November and December 2018. The actual sales and
Pavlova Instruments, a maker of precision telescopes needs a financial planning schedule for the months of October, November and December 2018. The actual sales and purchases for Pavlova Instruments for August and September 2018 along with its forecast sales and purchases for the period as follows: Month August September October November December Sales 27.000 28.000 29.000 30,000 31.000 Purchases 15,000 15,500 16,000 16,500 17.000 The firm makes 40 percent of all sales for cash and the credit sales will be collected equally one month and two months after sales. Other cash inflows are expected to be RM12,000 in September and October, RM11,000 in November and RM13,000 in December The firm paid 30 percent of purchases in cash, 40 percent of purchases paid in the following month and the remaining balance paid 2 months later. Wages and salaries expenses are 20 percent of the current monthly sales. Rent of RM8,000 must be paid monthly. Interest payments of RM8,000 are due in June and December. The firm expects to pay cash dividends of RM15,000 in October and taxes of RM11,000 are due in July. The firm also intends to make a RM10,000 cash purchase of fixed assets in November. The firm has a cash balance of RM5,000 on October 1 and wishes to maintain a minimum cash balance RM5,000. Interest on accumulated loan is at 12 percent annual interest and is paid every month Prepare the financial planning for the fourth quarter of year 2018 taking into consideration the above information for Pavlova Instruments
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started