Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

complete the spreadsheet with calculations and explanations. and possible questions ASSUMPTIONS begin{tabular}{|c|c|c|c|c|} hline & & 2022e & 2023e & 2024e hline Sales growth &

complete the spreadsheet with calculations and explanations. and possible questions
image text in transcribed
ASSUMPTIONS \begin{tabular}{|c|c|c|c|c|} \hline & & 2022e & 2023e & 2024e \\ \hline Sales growth & & 10% & 10% & 5% \\ \hline Gross margin & & 42% & 42% & 378 \\ \hline coGs & & 58% & 58% & 63% \\ \hline Accounts receivable is a proportion of sales & & 8% & 10% & 15% \\ \hline Inventory is a proportion of COGS & & 31% & 30% & 25% \\ \hline Notes payable payments/issuance & $ & (60.00)$ & & - \\ \hline Long-term debt. Additions at beginning of the year & $ & 457.00$ & 600.00;5 & 800.00 \\ \hline Depreciate NP\&E with the same amount & $ & 276.00$ & 276.00$ & 276.00 \\ \hline Tax rate will be & & 21% & 21% & 21% \\ \hline Interest rate will be & & 8% & 7% & 6.5% \\ \hline Payout ratio & & 33% & 33% & 33% \\ \hline Accounts payable is the same proportion of COGS in 2021 & & 26% & 28% & \\ \hline II of shares & & 8,000 & 8,000 & 8,000 \\ \hline WACC, see below & & & & \\ \hline \end{tabular}

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

Personal Financial Planning

Authors: Lawrence J. Gitman, Michael D. Joehnk

11th Edition

0324422865, 978-0324422863

More Books

Students also viewed these Finance questions

Question

What kind of salary are you offering for this position?

Answered: 1 week ago

Question

What is your greatest weakness?

Answered: 1 week ago