9. The following sheet presents a firm's balance sheets and income statement. 1 2 Assets A...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
9. The following sheet presents a firm's balance sheets and income statement. 1 2 Assets A 3 Current assets Cash Prepaid expenses B D BALANCE SHEET AND INCOME STATEMENT Liabilities and Equity Current liabilities E 4 5 10,000 1,500 Accounts payable 6 Total current assets Total current liabilities 2,000 2,000 11,500 7 Long-term liabilities 8 9 Fixed assets Debt 10,000 10 At cost 30,000 11 Accumulate depreciation Equity -14,000 12 Net Fixed assets Equity 10,500 16,000 Accumulated retained earnings 5,000 13 14 Total assets 27,500 Total liabilities and equity 27.500 15 16 Income statement 17 Sales 20,000 18 Cost of Goods Sold (COGS) -12,000 19 Depreciation -2,000 20 Interest on cash 300 21 Interest payments on debt -400 22 Profit before tax 5,900 23 Tax (40%) -2,360 24 Profit after tax 3,540 25 Dividend 26 Retained Earnings -708 2,832 a. You believe that these financial statements are representative of the firm's value drivers (For example, if the sales are $20,000 and the COGS are $12,000, then the COGS to sales param- eter is 60%). Find and calculate the value drivers that can be derived from the firm's balance sheet and P&L statement. b. Use the following data to project the financial statements for year 1: The sales growth is 12%. The depreciation is 10% of the average of the fixed assets value during the . The interest rate earned on cash is 5% on the average cash balances. The debt payments are $2,000 each year. . The interest rate on debt is 8%. year. loc. Show in a graph the change in the firm's profit relative to the change in the COGS. 9. The following sheet presents a firm's balance sheets and income statement. 1 2 Assets A 3 Current assets Cash Prepaid expenses B D BALANCE SHEET AND INCOME STATEMENT Liabilities and Equity Current liabilities E 4 5 10,000 1,500 Accounts payable 6 Total current assets Total current liabilities 2,000 2,000 11,500 7 Long-term liabilities 8 9 Fixed assets Debt 10,000 10 At cost 30,000 11 Accumulate depreciation Equity -14,000 12 Net Fixed assets Equity 10,500 16,000 Accumulated retained earnings 5,000 13 14 Total assets 27,500 Total liabilities and equity 27.500 15 16 Income statement 17 Sales 20,000 18 Cost of Goods Sold (COGS) -12,000 19 Depreciation -2,000 20 Interest on cash 300 21 Interest payments on debt -400 22 Profit before tax 5,900 23 Tax (40%) -2,360 24 Profit after tax 3,540 25 Dividend 26 Retained Earnings -708 2,832 a. You believe that these financial statements are representative of the firm's value drivers (For example, if the sales are $20,000 and the COGS are $12,000, then the COGS to sales param- eter is 60%). Find and calculate the value drivers that can be derived from the firm's balance sheet and P&L statement. b. Use the following data to project the financial statements for year 1: The sales growth is 12%. The depreciation is 10% of the average of the fixed assets value during the . The interest rate earned on cash is 5% on the average cash balances. The debt payments are $2,000 each year. . The interest rate on debt is 8%. year. loc. Show in a graph the change in the firm's profit relative to the change in the COGS.
Expert Answer:
Related Book For
Understanding financial statements
ISBN: 978-0136086246
9th Edition
Authors: Lyn M. Fraser, Aileen Ormiston
Posted Date:
Students also viewed these finance questions
-
I need help on this read from bottom to top. Image transcription text 7"} The second ?nancial statement to prepare is the statement of retained earnings. To determine the ending balance of...
-
This assignment requires you to complete the 2022 tax reporting for a fictional woman named Anna Smith. Question 1 T1 - step 4 - line 66 This is Anna's taxable income Answer: Question 2 T1 - step...
-
Alistair bought a house on 1 April 2000 for 125,000 and occupied the entire house as his principal private residence until 1 November 2008. As from that date, he rented out two rooms (comprising...
-
Adler owes Panessi, a police captain, $5,000. Adler threatens that unless Panessidischarges him from the debt, Adler will disclose the fact that Panessihas on several occasions become highly...
-
When are panel data regression models inappropriate? Give examples.
-
Below is a client prepared schedule that captures fixed assets and accumulated depreciation for the Rock View Corporation, and for which Molly Giles has completed audit work. Required: List the...
-
Consider a competitive market served by many domestic and foreign firms. The domestic demand for these firms product is Qd = 500 1.5P. The supply function of the domestic firms is QSD = 50 + 0.5P,...
-
Explore the impacts of the Coronavirus, the war in Ukraine, and other recent events and policies on supply and demand dynamics. Find articles using the sources listed below to identify fluctuations...
-
Using the information presented in Problem 13.4B, prepare a partial statement of cash flows for the current year, showing the computation of net cash flows from operating activities using the...
-
Dew Drop Inn sold 10 beds that had originally cost $500 each for a total of $1,200 cash. The depreciation recorded on the beds at the time of sale equals $4,000. The entry to record the sale includes...
-
Answer the following questions related to horizontal drilling: a. What are the conditions under which horizontal drilling operations would be considered? b. Would horizontal drilling operations be...
-
If reserves do not meet the requirements to be classified as proved developed or proved undeveloped, they must be classified as: a. Unproved b. Contingent reserves c. Contingent resources d. Possible...
-
Which of the following does not describe a use case? (a) An actor (user) that initiates an event. (b) An event that triggers a use case. (c) The use case that performs the actions triggered by the...
-
What is synthetic crude oil?
-
Which of the following are defined as exploration costs? a. Drilling and equipping exploratory wells b. Drilling exploratory-type stratigraphic test wells c. Dry-hole contributions d. Bottom-hole...
-
On January 1, 2018, Masterwear Industries issued $700,000 of 12% bonds, dated January 1. Interest of $42,000 is payable semiannually on June 30 and December 31. The bonds mature in three years. The...
-
What steps must a business take to implement a program of social responsibility?
-
Sara Lee Corporation is a manufacturer and marketer of high-quality, brand-name products such as Ambi Pur, Ball Park, Oouwe Egberts, Hillshire Farm, jimmy Dean, Kiwi, Sanex, Senseo, and its namesake,...
-
Access the SEC Web site: www.sec.gov /. Write a one-page summary explaining the items that a financial analyst might find useful at this Web site.
-
What are the particular items an analyst should review and study in an annual report, and what material should be read with caution?
-
Which of the following are boiler mountings ? (a) Economiser (b) Fusible plug (c) Super heater (d) Injector
-
Which out of the following boiler is capable of generating superheated steam without additional accessories ? (a) Cochran (b) Lancashire (c) Locomotive (d) Cornish
-
The economiser of the boiler plant is used mainly to (a) increase steam capacity (b) reduce fuel consumption (c) increase steam pressure (d) increase life of the boiler
Study smarter with the SolutionInn App