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:

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
Get step-by-step solutions from verified subject matter experts
