Question: I have to solve the following problem using the excel document below: King Fisher Aviation purchases from suppliers in a quarter are equal to 65%

I have to solve the following problem using the excel document below: I have to solve the following problem using the excel documentbelow: King Fisher Aviation purchases from suppliers in a quarter are equal

King Fisher Aviation purchases from suppliers in a quarter are equal to 65% of the next quarter's forecast sales. The payables period is 30 days. Wages, taxes, and other expenses are 25% of sales, and interest and dividends are $68 per quarter. Projected quarterly sales are as follows. Quarter 1 $1,300 Quarter 2 $1,400 Quarter 3 $1,400 Quarter 4 $1,200 Sales for the first quarter of the next year are projected to be $1,500. Calculate the company's cash outlays, by completing the following for each of the four quarters. Payment of accounts Wages, taxes, and other expenses Long-term financing expenses (interest and dividends) Total Fill in the values in the spreadsheet. Input Area: Purchases (% of sales) Projected sales Q(1) next year Expenses (% of sales) Payables period Interest & dividends per Q 65% 1,500 25% 30 days 68 $ 01 02 Q3 Q4 Sales $ 1,300 $ 1,400 $ 1,400 $ ** 1,200 Output Area: With a payables period of 30 Q1 02 Q2 Q3 Q4 Payment of accounts Wages, taxes, other expenses Long-term financing expenses Total

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!