Hello! please help me$,$ I need to fill out this statement of cash flows in this xcel format template. Please help me fill out the template correctly.

The following changes took place last year in Pavolik Company's balance sheet accounts:

Long$-$term investments that cost the company $$6$ were sold during the year for $$16$ and land that cost $$15$ was

sold for $$9.$ In addition, the company declared and paid $$30$ in cash dividends during the year. Besides the

sale of land, no other sales or retirements of plant and equipment took place during the year. Pavolik did not

retire any bonds during the year or issue any new common stock.

The company's income statement for the year follows:

The company's beginning cash balance was $$90$ and its ending balance was $$85.$

Required:

Use the indirect method to determine the net cash provided by operating activities for the year.

Prepare a statement of cash flows for the year.

Exercise $15-4$

Pavolik Company

Statement of Cash Flows

For the Year Ended December $31,2023$

Net Cash from Operating Activities:

Step $0$

Net Income

Step $1$

$+$Depreciation Expense

Step $2$ Current Adjustments

Step $3+$Losses$/-$Gains

Net Cash Provided by Operating Activities

Net Cash Used by Investing Activites:

Net Cash Used by Investing Activities

Net Cash Provided by Financing Activities:

Net Cash Provided by Financing Activities

Net Change in Cash

Beginning Cash

Ending Cash