Project 1 - Financial Statements

docx

School

Valencia College *

*We aren’t endorsed by this school

Course

2000

Subject

Finance

Date

Apr 3, 2024

Type

docx

Pages

Uploaded by Ronald6213

FIN6406 - Financial Management Project – Financial Analysis 1 Instructions The project will teach you how to perform a financial analysis on a set of financials. A financial analysis report is constructed by a person who is researching a company, usually with the intent of recommending its stock to investors or to a board of directors. The report contains multiple components, such as company overview, investment essentials, valuation, risk analysis, and a summary. However, for the purpose of this class, we will focus on the investment essentials. In this component – “investment essentials”, you will need to analyze the financials by using ratio analysis, trend analysis, and provide a quick summary of your findings. You as manager need to fully understand your role in the budgetary process. It is the most basic financial planning and control tool. Every manager needs to know what costs are associated with their department, and how in relation are they doing to that budget. You might achieve your departmental goals, but if you go over budget in order to achieve those goals, you create financial problems for the company and jeopardize your own job performance review. In most cases, part of your performance appraisal will be based on whether you were within budget for the year. Income statements show the results of a company’s operations, which are usually given quarterly or by fiscal year. It shows the sales, also known as revenue, and expenses. It also shows whether the company had a profit or loss during that period. The Income Statement is also known as the “Profit & Loss” statement or “P&L.” Simply put, the formula is: “Revenue – Expenses = Income.” The easiest and best scenario is, “The higher the sales and the lower the expenses, the greater the income.” There are all types of expenses that are generated in a company and this statement sees how the company is spending its money, and how management is most and least effective. As previously described, the Balance Sheet shows the value in the company’s accounts at a certain period, whereas the Income Statement covers operations over an entire period. Please recreate the financial statements below using excel. Please keep in mind that the financial statements below are unaudited. Therefore, there may be some errors found on both statements. Once the financial statements are recreated, please complete the following: 1. Prepare a common size income statement (10pts) 2. Prepare a common size balance sheet (10pts) 3. Prepare a trend analysis for the historical data for both financial statements and answer the following questions (30pts) a. What conclusion can you draw about Sales/Revenues between 2019 and 2020? b. What conclusion can you draw about COGS? c. What conclusion can you draw on Cash as a percentage of Total Assets? d. What conclusion can you draw on Inventory as a percentage of Total Assets?

4. Use the sheet labelled Notes on Financial Ratio Formula to calculate 3 ratios from each category for years 2019 and 2020 (20pts) 5. Prepare a pro-forma income statement – project income statement for years 2021 – 2022 – 2023. (15pts) 6. If total revenue grows by 10 percent in 2021, what is the company’s net income? (15pts) Please provide only excel file – all comments should be listed on the excel file.

Financial Statements for Sample Corp. 12/31/2020 12/31/2019 12/31/2020 12/31/2019 LIABILITIES and OWNERS' EQUITY Current Liabilities Cash $45,000 $40,000 Long-Term Debt – 1 Yr. $12,000 $11,000 Marketable Securities $65,000 $60,000 Notes Payable $15,000 $14,000 Accounts Receivable $85,000 $70,000 Accounts Payable $13,000 $12,000 Notes Receivable $45,000 $40,000 Taxes Payable $11,000 $10,000 Inventories $85,000 $80,000 Accrued Expenses $21,000 $20,000 Total Current Assets $325,000 $290,000 Other Current Liabilities $10,000 $9,000 Total Current Liabilities $82,000 $76,000 Land $160,000 $148,000 Buildings $100,000 $90,000 Notes Payable Machinery $30,000 $25,000 Bonds Payable –Accumulated Depreciation ($4,000) ($3,500) Total Long-Term Liabilities $0 $0 Net Tangible Assets $286,000 $259,500 Pension Obligations $90,000 $82,000 Goodwill $15,000 $5,000 Deferred Taxes $85,000 $74,000 Patents $20,000 $19,000 Minority Interest Trademarks $15,500 $13,400 Total Other Liabilities $175,000 $156,000 Copyrights $24,000 $22,900 Total Liabilities $257,000 $232,000 Total Intangibles $74,500 $60,300 Preferred Stock $60,000 $50,000 Common Stock $97,500 $89,000 Capital Surplus $111,000 $99,000 Total Long-Term Assets $360,500 $319,800 Retained Earnings $70,000 $60,800 Total Common Equity Total Owners' Equity $60,000 $50,000 Total Liabilities and Owners' Equity $317,000 $282,000 Total Assets ASSETS Common Equity $509,800 $650,000 Other Liabilities Intangible Assets OWNERS' EQUITY Balance Sheet - Sample Corp. Fiscal Year (FY) 2019, 2020 Current Assets Long-Term Assets Long-Term Liabilities

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

Sample Corp. FY 2019, 2020 Figures USD 2020 2019 Sales (Revenue) 15,500,000 14,625,000 Less: Cost of Goods Sold (COGS) (9,900,000) (10,500,000) Gross Income 5,600,000 4,125,000 Less: Selling, General, Administrative Costs (SG&A) (3,300,000) (2,350,000) Operating Income Before Depreciation (EBITDA) Less: Depreciation, Amortization, Depletion (11,000) (10,000) Operating Income (EBIT) Less: Interest Expense (93,000) (89,000) Non-operating Income Less: Non-operating Expenses (42,000) (40,000) Pretax Accounting Income -42,000 -40,000 Less: Income Taxes (1,350,000) (1,240,000) Income Before Extraordinary Items Less: Preferred Stock Dividends (87,000) (85,000) Income Available for Common Stockholders -87,000 -85,000 Less: Extraordinary Items (18,000) (15,000) Less: Discontinued Operations (400,000) (100,000) Adjusted Net Income Earnings Per Share (200,000 shares of stock) $0.00 $0.00 <---- (Net in Income Statement