Please see information attached to answer below questions.  Preferrably in Excel.    a1. Produce an income statement for 2020. Assume that net working capital will equal 50% of fixed assets. a2. Produce a balance sheet for 2020. Assume that net working capital will equal 50% of fixed assets. b. Now assume that the balancing item is debt and that no equity is to be issued. Prepare a completed pro forma balance sheet for 2020. c. Assume that the balancing item is debt and that no equity is to be issued, what is the projected debt ratio for 2020?

As part of your analysis, you are required to investigate Insignia Corporation Limited’s cash flows. Required: Using the financial statement provided: Calculate the following for 2020: Operating Cash Flow Net Capital Spending Change in Net Working Capital

Using the following Balance Sheet summary information, for the two years presented calculate the working capital for 2018 and 2019 respectively: Current Assets 12/31/2018 is $101,600/ 12/31/2019 is $97,350 current liabilities 12/31/2018 is $33,650/ 12/31/2019 is $32,800

a) Bank B reported a debt to equity ratio of 8.5 at the end of year 2019. If the 'bank's total assets at the end of year 2019 was $28 million, how much of its assets were financed with equity?

Determine the WACC, and determine whether the company generated value or not, and what the amount was for both years   ANSWER     2020 2021 WACC     EVA     ROIC

Pasta Corporation acquired 75% of Sauce Company on January 1, 2020 for $566,250 cash. The fair value of the other 25% ownership interest is estimated to be $188,750. ADDITIONAL INFORMATION: On the date of acquisition: * The Book Value of Sauce Company's net identifiable assets was $652,000. * Sauce's Company's Plant Assets were undervalued by $75,000 (remaining life was estimated to be 5 years). * Sauce's Company's Inventories were overvalued by $9,000 (all sold by year end). * New Goodwill was determined to be $37,000. At year-end, it was determined that the New Goodwill was impaired by $5,800. * For 2020, Sauce reported net income of $146,500 and paid dividends of $26,000. Assume that Pasta Company uses the fully adjusted equity method to account for its Investment in Sauce.

Need assistance with (a) (4) through (7)

True or False?   You can construct a sources and use statement for 2021 if you have a company's year-end balance sheets for 2021 and 2022

Following are the current asset and current liability sections of the balance sheets for Freedom Incorporated at January 31, 2023 and 2022 (in millions): Current Assets Cash Accounts receivable Inventories Total current assets Current Liabilities Note payable Accounts payable Other accrued liabilities Total current liabilities Req A January 31, 2023 $12 8 7 $ 27 Req B and C Working capital Current ratio 4 3 $ 11 January 31, 2022 Required: a. Calculate the working capital and current ratio at each balance sheet date. b. Evaluate the firm's liquidity at each balance sheet date. c. Assume that the firm operated at a loss during the year ended January 31, 2023. How could cash have increased during the year? $ 9 11 11 $ 31 Complete this question by entering your answers in the tabs below. 1 3 01/31/2023 01/31/2022 $8 Calculate the working capital and current ratio at each balance sheet date. Note: Enter "Working capital" in millions of dollars (i.e., 10,000,000 should be entered as 10).…