Start with the partial model in the file Ch08 P25 Build a Model.xlsx. Selected data for the Derby Corporation are shown here. Use the data to answer the questions. INPUTS (In Millions) Year Current 0 Projected 1 2 3 Free cash flow -$25.0 $25.0 $90.0 $97.2 Marketable securities $ 30 Notes payable Long-term bonds Preferred stock $240 $ 40 WACC Number of shares of stock 12.00% 50 The data has been collected in the Microsoft Excel file below. Download the spreadsheet and perform the required analysis to answer the questions below. Do not round intermediate calculations. Download spreadsheet Ch08 P25 Build a Model-276077.xxx a. Calculate the estimated horizon value (ie, the value of operations at the end of the forecast period immediately after the Year-4 free cash flow). Assume growth becomes constant after Year 3. Enter your answer in millions. For example, an answer of $1.23 million should be entered as 1.23, not 1,230,000. Round your answer to two decimal places. $ milion b. Calculate the present value of the horizon value, the present value of the free cash flows, and the estimated Year-0 value of operations. Enter your answers in millions. For example, an answer of $1.23 million should be entered as 1.23, not 1,230,000. Round your answers to two decimal places. Present value of HV Present value of FCF Value of operations milion milion milion c. Calculate the estimated Year-0 price per share of common equity. Round your answer to the nearest cent.

Exercise n°6. Consider this simplified balance sheet for Geomorph Trading: Current liabilities Long-term debt Other liabilities Equity Current assets $ 100 $ 60 Long-term assets 500 280 70 190 $ 600 $ 600 a. Calculate the ratio of debt to equity. (Round your answer to 2 decimal places.) b-1. What are Geomorph's net working capital and total long- term capital? b-2. Calculate the ratio of debt to total long-term capital. (Round your answer to 2 decimal places.) Exercise n°7. Magic Flutes has total receivables of $3,000, which represent 20 days' sales. Total assets are $75,000. The firm's operating profit margin is 5%. Assume a 365-day year. 3/4 a. What is the firm's sales-to-assets ratio? (Round your answer to 2 decimal places.) b. What is the firm's return on assets? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.) Exercise n°8. a. If a firm's assets of $10,000 represent 200 days' sales, what is its annual sales? Assume a 365-day…

Give true solution for this accounting question

General Finance

213erform the 3 step DuPont Return on Equity (ROE) analysis for Brady Corp. using cell references. (25 pts) Write a brief analysis (50-100 words) of what you learn from the DuPont analysis on your Excel worksheet. Balance Sheet ($000) Ratios Calculation Assets Liabilities and Equity Liquidity Cash 2$ Accounts payable Notes payable 1,500 12,500 Current Marketable securities $ $ $ 2,500 12,500 Quick Accounts receivable 15,000 Total current liabilities $ 25,000 Inventory 33,000 Long-term debt 22,000 Asset Management Total current assets 2$ 52,000 Total liabilities 47,000 Average collection period Fixed assets (net) 35,000 Common stock (par value) 2$ 5,000 Inventory turnover Total assets $ Fixed-asset turnover Contributed capital in excess of par Retained earnings 87,000 18,000 17,000 Total asset turnover Total stockholders' equity 40,000 Total liabilities and stockholders' equity 87,000 Financial Leverage Debt Income Statement ($000) Other Info Debt-to-equity Times interest earned Sales…

From the following information calculate the net asset values. (Round your answers to the nearest cent.) Current market value Current liabilities Number of NAV of fund investment shares outstanding $ 5,790,000 $ 890,000 400,000 a. b. 14,280.000 $ 900,000 960.000

On the basis of this information, calculate as many liquidity, activity, leverage, profitzit and common stock measures as you can. (Note: Assume the current market price of the common stock is $75 per share.

Calculate Quick Ratio: AKA the Acid Test

Refer the following table. Cash Tia's Trampolines Inc. Comparative Balance Sheet Information November 30 (millions of $) Accounts receivable (net) Plant and equipment (net) Accounts payable Long-term notes payable Preferred shares 2023 $ 205 280 2022 $ 593 2021 $ 618 317 136 1,446 1,530 1,826 60 136 224 965 1,285 1,445 165 165 165 645 645 645 96 209 101 Connon shares Retained earnings The preferred shares are $0.50, non-cumulative 80 million preferred and 320 million common shares were issued and outstanding during each year. Net sales Tia's Trampolines Inc. Income Statement For Year Ended November 30 (millions of $) Cost of goods sold Gross profit Operating expenses: Depreciation expense Other expenses Total operating expenses Profit from operations Interest expense Income tax expense Profit 2023 2022 2021 $4,020 $6,340 $6,660 2,769 4,393 4,617 $1,251 $1,947 $2,843 $ 306 $ 306 $ 306 402 1,258 1,454 708 1,564 1,760 $ 543 $ 383 $ 283 68 157 87 109 97 74 $ 318 $187 $112 Required:…

The re-issuance of treasury stock for cash would be reported on a statement of cash flows under the following section: O Investing O Leases O Borrowing O Operarting O Bonds O Financing ASUS f4 f9 团 f5 f6 f7 f10 f11 & 4 6 Y U F G H. K V B N 08 因 5 %24