The Frontline Corporation's projected sales for the first 8 months of 2019 are shown in the...

60.1K

Verified Solution

Question

Finance

The Frontline Corporation's projected sales for the first 8months of 2019 are shown in the table below.

Jan$        190,000May$    300,000
Feb          120,000Jun       270,000
Mar          135,000Jul       225,000
Apr          240,000Aug       150,000

Of Frontline's sales, 10% is for cash, 60% is collected in themonth following the sales, and 30% is collected in the second monthfollowing sales. November and December 2018 sales were $220,000 and$175,000, respectively. Frontline purchases its raw materials 2months in advance of its sales. The purchases are equal to 60% ofthe final sales price of Frontline's products. The supplier is paidone month after it makes a delivery. For example, purchases forApril sales are made in February and payment is made in March. Inaddition, Frontline pays $10,000 per month for rent and $20,000each month for other expenditures. Tax prepayments of $22,500 aremade every three months beginning in March. The compnay's cashbalance on December 31, 2018 was $22,000. This is the minimumbalance the company wants to maintain. Any borrowing that is neededto maintain this minimum is paid off in the subsequent month ifthere is sufficient cash. Interest on short-term loans (12% annualinterest) is paid monthly. Borrowing to meet estimated monthly cashneeds taks place at the beginning of the month. Thus, if in themonth of April the firm expects to have a need for an additional$60,500, these funds would be borrowed at the beginning of Aprilwith interest of $605 (12% x 1/12 x $60,500) owed for April andpaid at the beginning of May.

Answer & Explanation Solved by verified expert
3.5 Ratings (448 Votes)
CASH BUDGET Particulars Jan Feb Mar Apr May Jun Jul Opening Cash Balance 22000 110000 177500 123500 54500 77000 170000 Receipts Collection from Sales 190000 178500 142500 141000 214500 279000 274500 Total Receipts A 190000 178500 142500 141000 214500 279000 274500 Payments Payment of Raw Materials 72000 81000    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Transcribed Image Text

The Frontline Corporation's projected sales for the first 8months of 2019 are shown in the table below.Jan$        190,000May$    300,000Feb          120,000Jun       270,000Mar          135,000Jul       225,000Apr          240,000Aug       150,000Of Frontline's sales, 10% is for cash, 60% is collected in themonth following the sales, and 30% is collected in the second monthfollowing sales. November and December 2018 sales were $220,000 and$175,000, respectively. Frontline purchases its raw materials 2months in advance of its sales. The purchases are equal to 60% ofthe final sales price of Frontline's products. The supplier is paidone month after it makes a delivery. For example, purchases forApril sales are made in February and payment is made in March. Inaddition, Frontline pays $10,000 per month for rent and $20,000each month for other expenditures. Tax prepayments of $22,500 aremade every three months beginning in March. The compnay's cashbalance on December 31, 2018 was $22,000. This is the minimumbalance the company wants to maintain. Any borrowing that is neededto maintain this minimum is paid off in the subsequent month ifthere is sufficient cash. Interest on short-term loans (12% annualinterest) is paid monthly. Borrowing to meet estimated monthly cashneeds taks place at the beginning of the month. Thus, if in themonth of April the firm expects to have a need for an additional$60,500, these funds would be borrowed at the beginning of Aprilwith interest of $605 (12% x 1/12 x $60,500) owed for April andpaid at the beginning of May.

Other questions asked by students