Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

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

The Handbook Of Post Crisis Financial Modelling

Authors: Emmanuel Haven, Philip Molyneux, John Wilson, Sergei Fedotov, Meryem Duygun

1st Edition

1137494484, 978-1137494481

More Books

Students also viewed these Finance questions

Question

7. List behaviors to improve effective leadership in meetings

Answered: 1 week ago

Question

6. Explain the six-step group decision process

Answered: 1 week ago