Please Read Carefully Before start answering this question. Please follow the instructions.

This Question is from'BSBFIM501 Manage budgets and financial plans'course. There are no parts missing for this Question; guaranteed!. This is the original Screenshot direct from the question. Therefore, there are nothing any further information can be provided.Thanks for your understanding and Cooperation.

Question 4 From your experience you estimate that 75% of Debtors would pay within the first month from the sale, 16% within the second month, 7% within the third and 2% will be written off as bad debts. Your Credit Terms with your suppliers stipulate they must pay within 45 days of purchasing. Using Excel, complete a quarterly Aged Debtors Budget for your department using the information above as well as any required information provided in previous sections. Equation functions must be used for all calculations. Total Q1 02 03 04 Sales 6000000 $1,200,000 $1,950,000 $1,650,000 $1,200,000 Current 30 days 60 days Bad Debts Please provide a copy of your excel worksheet and include a reference to the question number. OR Alternatively attach a copy of your excel worksheet showing your final budget and a second copy showing your formulas where applicable