Please help with how to fill out the assumptions since all cells need to be referenced.

We will need to do an aging analysis, worksheet, adjusting entries, income statement, statement of retained earnings, closing entries and balance sheet. I've started I just need help completing the assumptions.

Use the following information to prepare adjusting entries for Broomfield Industries: On July 1, 2019, Broomfield Industries signed a 4.2% bank loan due in 3 years. This is the only outstanding note payable. Prepaid insurance represents a 12-month insurance policy purchased on May 1. On November 1, 2019, Broomfield Industries paid $12,780 for a 4-month lease for office space. Unearned revenue represents a 8-month contract for consulting services. The payment was received on October 1, 2019. Supplies on hand total $4,674. Equipment is depreciated on a straight-line basis; residual value is estimated to be $12,000 with an estimated service life of 10 years. The assets were held the entire year. On August 1, Broomfield Industries issued Denver Supplies an 9-month note receivable at a 5.7% annual interest rate. The company uses the percentage-of-receivables basis for estimating uncollectible accounts. The aging schedule of accounts receivable must be completed to determine management's desired balance for 2019. Accrued wages totaling $71,490 were unpaid and unrecorded at December 31, 2019. Utility costs incurred but unrecorded for the month of December were estimated to be $12,314. Assumptions 4.20% 5 Interest rate on note payable Interest policy term in months used - Policy overall - 12 - Prepaid insurance policy for 12 months in terms of months used Prepaid insurance policy for 12 months Use the following information to prepare adjusting entries for Broomfield Industries: On July 1, 2019, Broomfield Industries signed a 4.2% bank loan due in 3 years. This is the only outstanding note payable. Prepaid insurance represents a 12-month insurance policy purchased on May 1. On November 1, 2019, Broomfield Industries paid $12,780 for a 4-month lease for office space. Unearned revenue represents a 8-month contract for consulting services. The payment was received on October 1, 2019. Supplies on hand total $4,674. Equipment is depreciated on a straight-line basis; residual value is estimated to be $12,000 with an estimated service life of 10 years. The assets were held the entire year. On August 1, Broomfield Industries issued Denver Supplies an 9-month note receivable at a 5.7% annual interest rate. The company uses the percentage-of-receivables basis for estimating uncollectible accounts. The aging schedule of accounts receivable must be completed to determine management's desired balance for 2019. Accrued wages totaling $71,490 were unpaid and unrecorded at December 31, 2019. Utility costs incurred but unrecorded for the month of December were estimated to be $12,314. Assumptions 4.20% 5 Interest rate on note payable Interest policy term in months used - Policy overall - 12 - Prepaid insurance policy for 12 months in terms of months used Prepaid insurance policy for 12 months