Please answer this question by Using Excel Function(Complusary) in an Excel Documents. I will appreciate your answer with thumbs up .

Here is the answer of above question but teacher wants answer must using Excel Function(Complusary) . I hope so you will be understand what I want. Thanks

please I need answer by using Excel Function (Complusary) in an Excel Document. I will appreciate you

2,L04-3,LO4-4,1-6,LO4-7,LO4-9 4.3 f Adjusted Data Gunflint Adventures operates an airplane service that takes fishing parties to a remote lake resort in northern Manitoba, Canada. Individuals must purchase their tickets at least one month in advance during the busy summer season. The company adjusts its accounts only once each month. Selected balances appearing in the company's June 30 adjusted trial balance appear as follows. Other Information 1. The airplane is being depreciated over a 15 -year life with no residual value. 2. Unearned passenger revenue represents advance ticket sales for bookings in July and August at $300 per ticket. 3. Six months' airport rent had been prepaid on May 1 . 4. The unexpired insurance is what remains of a 12-month policy purchased on February 1. 5. Passenger revenue earned in June totaled $40,000. Instructions a. Determine the following. 1. The age of the airplane in months. 2. The monthly airport rent expense. 3. The amount paid for the 12-month insurance policy on February 1. b. Prepare the adjusting entries made on June 30 involving the following accounts. 1. Depreciation Expense: Airplane 2. Airport Rent Expense 3. Insurance Expense 4. Passenger Revenue Earned ANSWERS FOR A: 1. 15 years 12 mo's =180 months old 2. $9,000/4 mo's =$2,250 per month 3. $4,200/7 mo's remaining =$6005 mo's that passed =$3,000+$4,200=$7,200 ANSWERS FOR B: \begin{tabular}{|l|l|l|l|c|c|} \hline 30-Jun & Depreciatidn Expense:Airplane & & $1,600 & \\ \hline & Accumulated Depreciation: Airplane & & & $1,600 \\ \hline & June Airplane Adjusting Entry & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|l|l|} \hline 30-Jun & Export Rent Expense & & & & $2,250 & \\ \hline & Unexpired Rent & & & & & $2,250 \\ \hline & Adjusting entry to recdrd rent expense & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|l|l|l|l|l|} \hline 30-Jun & Insurance Expense & & & & $600 & \\ \hline & Unexpired Insurance & & & & & $600 \\ \hline & Adjusting entry to record insurance expense & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|c|c|} \hline 30-Jun & Unearned Rassenger Revenue & & $40,000 & \\ \hline & Passenger Revenue Earned & & & $40,000 \\ \hline & Adjusting entry to recdrd passender revenue earned & & & \\ \hline \end{tabular} Gunflint Adventures operates an airplane service that takes fishing parties to a remote lake resort in northern Manitoba, Canada. Individuals must purchase their tickets at least one month in advance during the busy summer season. The company adjusts its accounts only once each month. Selected balances appearing in the company's June 30 adjusted trial balance appear as follows. Other Information 1. The airplane is being depreciated over a 15 -year life with no residual value. 2. Unearned passenger revenue represents advance ticket sales for bookings in July and August at $300 per ticket. 3. Six months' airport rent had been prepaid on May 1 . 4. The unexpired insurance is what remains of a 12-month policy purchased on February 1. 5. Passenger revenue earned in June totaled $40,000. Instructions a. Determine the following. 1. The age of the airplane in months. 2. The monthly airport rent expense. 3. The amount paid for the 12-month insurance policy on February 1 . b. Prepare the adjusting entries made on June 30 involving the following accounts. 1. Depreciation Expense: Airplane 2. Airport Rent Expense 3. Insurance Expense 4. Passenger Revenue Earned