completed question

Assets: CashAccountsReceivableInventoriesTotalcurrentassetsFixedassetsTotalassets$28,645$125,464$198,223$352,332$175,400$527,732 Liabilities and equity Additional Data: 2021 Sales =$575,125 Projected 2022 sales growth =12.0000% 2021 Net Income =$55,651 2021 Dividends Paid =$26,712 Tax Rate =25% Company was operating at FULL Capacity Calculate the Profit Margin (M) and the Payout Ratio Using the AFN equation, determine the total external funds needed based on 2022 projected 12% sales growth Determine Self-Supporting Growth Rate for the company if they decide NOT to use any external sources of funding Use the Self-Supporting Growth Rate to estimate the Projected Sales without using external sources of funding Enter the calculated answers on the Worksheet: Capital Intensity Ratio \% Total Assets Needed \$ Spontaneous Liabilities $ Change in Retained Earnings \$ Additional Funds Needed (AFN) Self-Supporting Growth Rate \% Projected Sales without using external sources of funding $ Assets: CashAccountsReceivableInventoriesTotalcurrentassetsFixedassetsTotalassets$28,645$125,464$198,223$352,332$175,400$527,732 Liabilities and equity Additional Data: 2021 Sales =$575,125 Projected 2022 sales growth =12.0000% 2021 Net Income =$55,651 2021 Dividends Paid =$26,712 Tax Rate =25% Company was operating at FULL Capacity Calculate the Profit Margin (M) and the Payout Ratio Using the AFN equation, determine the total external funds needed based on 2022 projected 12% sales growth Determine Self-Supporting Growth Rate for the company if they decide NOT to use any external sources of funding Use the Self-Supporting Growth Rate to estimate the Projected Sales without using external sources of funding Enter the calculated answers on the Worksheet: Capital Intensity Ratio \% Total Assets Needed \$ Spontaneous Liabilities $ Change in Retained Earnings \$ Additional Funds Needed (AFN) Self-Supporting Growth Rate \% Projected Sales without using external sources of funding $