Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Problem Statement Define problems, issues and objectives within the organization and upper management team is facing Financial Analysis Common Size for I.S and BS Vertical

image text in transcribed

Problem Statement

Define problems, issues and objectives within the organization and upper management team is facing Financial Analysis

Common Size for I.S and BS Vertical and Horizontal Analysis Cross Sectional Evaluate Ratios Compare with competitors Industrial benchmarking Recommendation

Address current issues and problems identified Provide strategy to achieve the company's objectives Conclusion

Recap your findings and solutions Provide a forecasting income stateme

\begin{tabular}{|c|c|c|c|} \hline & 2023 & 2022 & 2021 \\ \hline Sales & $1,620,000 & $1,650,000 & $1,690,000 \\ \hline cogs & $235,000 & $225,000 & $220,000 \\ \hline Gross profit & $1,385,000 & $1,425,000 & $1,470,000 \\ \hline Operating expenses & $750,000 & $650,000 & $630,000 \\ \hline Operating proft & $635,000 & $775,000 & $840,000 \\ \hline Interest Expense & $35,000 & $35,000 & $35,000 \\ \hline Tax & $162,000 & $199,800 & $217,350 \\ \hline \multirow[t]{2}{*}{ Net income } & $438,000 & $540,200 & $587,650 \\ \hline & 2023 & 2022 & 2021 \\ \hline Cash & $345,000 & $424,000 & $421,000 \\ \hline Accounts receivable & $153,000 & $140,000 & $144,000 \\ \hline Inventory & $100,000 & $120,000 & $90,000 \\ \hline Net PPE & $1,250,000 & $1,300,000 & $1,350,000 \\ \hline Total & $1,848,000 & $1,984,000 & $2,005,000 \\ \hline Accounts payable & $42,000 & $48,000 & $41,000 \\ \hline Note Payable & $50,000 & $45,000 & $46,000 \\ \hline Bank Loan & $350,000 & $350,000 & $350,000 \\ \hline Total & $442,000 & $443,000 & $437,000 \\ \hline Common Share & $800,000 & $1,000,000 & $1,000,000 \\ \hline Retained Earnings & $606,000 & $541,000 & $568,000 \\ \hline Total Liabilities and Shareholder's Equity & $1,848,000 & $1,984,000 & $2,005,000 \\ \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

Accounting Major By Day Gamer By Night

Authors: Accountant Notes

1st Edition

1687764158, 978-1687764157

More Books

Students also viewed these Accounting questions