Book1

.xls

School

Elementary College of Education For Women Skardu *

*We aren’t endorsed by this school

Course

HUMAN RESO

Subject

Finance

Date

Nov 24, 2024

Type

xls

Pages

5

Uploaded by Timwoods

Report
The Financial Numbers Required Initial Investment=Initial CAPEX+Working CapitalRequired Initial Investment=Initial CAPEX+Working Capital Capital expenditures -8,147 Working capital -2,518 -10,665 Total revenue as per 2023 99,891 Total revenue as per 2020 50,734 $0.25 Year Eastimated revenue value 2023 99,891 $125,199.36 2024 $125,199.36 $156,919.84 2025 $156,919.84 $196,677.02 2026 $246,507.06 $308,962.04 2027 $308,962.04 $387,240.59 Find the annual growth rate for every single item on the income statement. Future growth may be predicted using historical from 2021 to 2022 revenue of 2022 99,891 revenue of 2021 66,070 0.005 from 2020 to 2021 revenue of 2021 66,070 revenue of 2020 50,734 0.0030 Average of these growth rates: 0.0051 Year Projected Profit 2023 100,404 a. Required Initial Investment C. Projected Profit each year for the next 3 to 5 years.
2024 100919.33 2025 101437.46 2006 101958.25 2027 101958.25 Formula: ((Total Revenue in Current Period) - (Total Revenue in Previous Period)) / (Total Revenue in Previous Period) Total revenue in current period 99,891 Total Revenue in Previous Period 66,070 51.19 Formula: (Gross Profit / Total Revenue) * 100 Gross Profit 20,731,607 Total Revenue 99,891 20754.23 Operating Margin Formula: (Operating Income / Total Revenue) * 100 Operating Income is not given (OperatingIncome=NetOperatingCashFlow−Non−OperatingItems) Net Operating Cash Flow 7,975 Non Operating Income -57 7,918 Operating Income 7,918 Total Revenue Operating Margin net income 7,918 Total Revenue 99,891 Net Profit Margin: 7.93 Return on Assets (ROA): Formula: (Net Income / Total Assets) * 100 Net income 16,298 Total Assets 87,950 Return on Assets (ROA): 18.53 D. Key Financial Performance Metrics Revenue Growth Rate : Gross Margin : Gross Margin :
Return on Equity (ROE): Formula: (Net Income / Stockholders' Equity) * 100 Net income 16,298 Stockholder's equity 87,950 Return on Equity (ROE): 18.53 Earnings Per Share (EPS): Formula: (Net Income / Diluted Average Shares) Net income 16,298 Diluted Average Shares 533 30.58 Current Ratio: Formula: Current Assets / Current Liabilities Current Assets 57,769 Current liabilities 18,081 Current Ratio: 3.20
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
UST The last few years' yearly CAGR = [(Ending Value / 2024: Approximately $125,199.36 2025: Approximately $75,135,246.03 2026: Approximately $196,677.02 2027: Approximately $$308,962.04 2028: Approximately $$387,240.59 l growth rates. We'll assume consistent growth based on the TTM and data from the previous two years:
y sales growth rate. Use the CAGR formula: Beginning Value) ^ (1 / Number of Years)] - 1