For the next four $(4)$ questions, you will need the supplemental Excel file found HERE.

Imagine that you are an Associate at a private equity firm that focuses on investments in the Financial Services space. In the Excel file, you will find an Income Statement for an insurance broker.

Insurance brokers primarily generate revenue from commissions and fees, which can be projected based on a percentage of total insurance premiums sold by the broker. To a lesser extent, insurance brokers can generate revenue through interest income on the premiums collected and held by the broker for a short period of time before passing these funds to the insurance companies. This interest income can be projected based on year$-$over$-$year growth.

Complete the Income Statement projection for the insurance broker using the assumptions provided for you in the Excel file. Once done, answer the following questions.

NOTE: You are working only in the yellow shaded cells. The Excel file is already formatted for you. To avoid calculation errors, do not change the formatting in the file.

Question $1$ of $4$: At what rate is the insurance broker expected to grow total revenue in $2024$F$?$

Question $2$ of $4$: How much in total premiums is the insurance broker expected to sell in $2026$F$?$

Question $3$ of $4$: How much is the insurance broker expected to earn in Commissions & Fees in $2028$F$?$

Question $4$ of $4$: How much total revenue is the insurance broker expected to generate in $2030$F$?$