Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What would be the excel equation for the AFN? Problem 9-4 begin{tabular}{|l|rr|} hline multicolumn{2}{|c|}{ INPUT } & hline Sales 2021 & $ & 5,000,000

What would be the excel equation for the AFN?image text in transcribed

Problem 9-4 \begin{tabular}{|l|rr|} \hline \multicolumn{2}{|c|}{ INPUT } & \\ \hline Sales 2021 & $ & 5,000,000 \\ \hline Assets 2021 & $ & 2,500,000 \\ \hline Notes payable 2021 & $ & 300,000 \\ \hline Accounts payable 2021 & $ & 500,000 \\ \hline Accruals 2021 & $ & 200,000 \\ \hline Profit margin & & 7.0% \\ \hline Dividend payout ratio & 80.0% \\ \hline \end{tabular} \begin{tabular}{|l|rr|} \hline \multicolumn{2}{|c}{ OUTPUT } & \\ \hline Self Supporting Growth Rate & & 3.63% \\ \hline M(1POR)S0 & $ & 70,000 \\ \hline A00L0M(1POR)S0 & $ & 1,930,000 \\ \hline \end{tabular} Complete the alternate method of calculating the Self-Supporting Growth Rate Forecasted Growth Rate 5.00% AFN Problem 9-4 \begin{tabular}{|l|rr|} \hline \multicolumn{2}{|c|}{ INPUT } & \\ \hline Sales 2021 & $ & 5,000,000 \\ \hline Assets 2021 & $ & 2,500,000 \\ \hline Notes payable 2021 & $ & 300,000 \\ \hline Accounts payable 2021 & $ & 500,000 \\ \hline Accruals 2021 & $ & 200,000 \\ \hline Profit margin & & 7.0% \\ \hline Dividend payout ratio & 80.0% \\ \hline \end{tabular} \begin{tabular}{|l|rr|} \hline \multicolumn{2}{|c}{ OUTPUT } & \\ \hline Self Supporting Growth Rate & & 3.63% \\ \hline M(1POR)S0 & $ & 70,000 \\ \hline A00L0M(1POR)S0 & $ & 1,930,000 \\ \hline \end{tabular} Complete the alternate method of calculating the Self-Supporting Growth Rate Forecasted Growth Rate 5.00% AFN

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Airline Management Finance

Authors: Victor Hughes

1st Edition

1138610690, 978-1138610699

More Books

Students also viewed these Finance questions

Question

Explain exothermic and endothermic reactions with examples

Answered: 1 week ago

Question

Write a short note on rancidity and corrosiveness.

Answered: 1 week ago

Question

List behaviors to improve effective leadership in meetings

Answered: 1 week ago