Argo Airlines, a privately held firm, is looking to buy additional gates at its home airport...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Argo Airlines, a privately held firm, is looking to buy additional gates at its home airport for $350,000. Argo has money in the bank but that money may not be spent as it is used to pay salaries, suppliers, and equipment. Argo asked its bank for a loan but the bank refused saying that Argo's interest-bearing debt to equity was too high. The bank said that Argo needed to lower that ratio below 0.5 in order to get the loan. Separately, SkyBlue Airlines has approached Argo to see if Argo will buy it. 4. The price discussed by the two CEOS is 24.5x SkyBlue's 2020 net earnings You must calculate this price and compare it with the free cash flow value of SkyBlue, which you must also calculate. The CFO wants to know if Argo is overpaying or underpaying for SkyBlue. A E F Actual Projected 1 2 Income Statement 2020 2021 2022 2023 Notes - S,G & A Expenses 1,199 1,239 1,281 1,326 Use same percent of Net Sales as in 2018 10 = EBIT 334 345 357 369 Calculation (Use for Free Cash Flow valuation!) 11 - Interest 77 77 77 77 Hold level 12 = EBT 257 268 280 292 Calculation 13 - Taxes 54 56 59 61 Use implicit rate of 2018 14 = Net Income 203 212 221 231 Calculation 15 Balance Sheet 16 Cash 230 238 245 254 17 Notes and Acc. Rec. 664 686 709 732 18 Inventory Increase at average growth rate 788 715 739 763 19 Prepaid 65 67 69 72 20 Current Assets 1,674 1,729 1,786 1,845 21 Other 102 102 102 102 Increase at average growth rate 22 Total Assets 1,776 1,831 1,888 1,947 23 177 Plug to make balance sheet balance 36 Increase at average growth rate 24 Bank Loan 550 433 309 25 Payables 33 34 35 26 CPLTD 42 42 42 42 Leave flat 27 Other 34 35 36 38 Increase at average growth rate 28 Current Liabilities 659 545 423 293 125 83 41 (1) LTD of previous year minus CPLTD of current yea 1,656 Equity of previous year plus net income of current y 1,947 29 LTD 30 Equity 31 Total Liabilities & Equity 992 1,204 1,425 1,776 1,831 1,888 32 33 Working Capital 1,565 1,618 1,673 1,729 Exclude Bank Loan Argo Airlines, a privately held firm, is looking to buy additional gates at its home airport for $350,000. Argo has money in the bank but that money may not be spent as it is used to pay salaries, suppliers, and equipment. Argo asked its bank for a loan but the bank refused saying that Argo's interest-bearing debt to equity was too high. The bank said that Argo needed to lower that ratio below 0.5 in order to get the loan. Separately, SkyBlue Airlines has approached Argo to see if Argo will buy it. 4. The price discussed by the two CEOS is 24.5x SkyBlue's 2020 net earnings You must calculate this price and compare it with the free cash flow value of SkyBlue, which you must also calculate. The CFO wants to know if Argo is overpaying or underpaying for SkyBlue. A E F Actual Projected 1 2 Income Statement 2020 2021 2022 2023 Notes - S,G & A Expenses 1,199 1,239 1,281 1,326 Use same percent of Net Sales as in 2018 10 = EBIT 334 345 357 369 Calculation (Use for Free Cash Flow valuation!) 11 - Interest 77 77 77 77 Hold level 12 = EBT 257 268 280 292 Calculation 13 - Taxes 54 56 59 61 Use implicit rate of 2018 14 = Net Income 203 212 221 231 Calculation 15 Balance Sheet 16 Cash 230 238 245 254 17 Notes and Acc. Rec. 664 686 709 732 18 Inventory Increase at average growth rate 788 715 739 763 19 Prepaid 65 67 69 72 20 Current Assets 1,674 1,729 1,786 1,845 21 Other 102 102 102 102 Increase at average growth rate 22 Total Assets 1,776 1,831 1,888 1,947 23 177 Plug to make balance sheet balance 36 Increase at average growth rate 24 Bank Loan 550 433 309 25 Payables 33 34 35 26 CPLTD 42 42 42 42 Leave flat 27 Other 34 35 36 38 Increase at average growth rate 28 Current Liabilities 659 545 423 293 125 83 41 (1) LTD of previous year minus CPLTD of current yea 1,656 Equity of previous year plus net income of current y 1,947 29 LTD 30 Equity 31 Total Liabilities & Equity 992 1,204 1,425 1,776 1,831 1,888 32 33 Working Capital 1,565 1,618 1,673 1,729 Exclude Bank Loan
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
The Johari Window emphasizes that we may not be aware of everything that there is to know about ourselves. Others may know things about us that we just cannot see or are unwilling to admit. One way...
-
Apache Airlines, a privately held firm, is looking to buy additional gates at its home airport for $800,000 Apache has $240,000 in the bank but that money may not be spent as it is used to pay...
-
A large consulting firm is looking to expand the services currently offered its clients. The firm has developed a new performance metric called Economic Earnings, or EE for short. The performance...
-
Nevada Department Stores is planning to sell its Spring Valley. Fernley, and Winchester stores. The firm expects to sell each of the three stores for the same, positive cash flow of SD. The firm...
-
What is the difference between the target of controls tests and the target of substantive procedures?
-
As part of a promotion campaign, Funzy Cereal includes one coupon in each issue of various national magazines and offers a toy car in exchange for $1.40 and four coupons. The cars cost Funzy $1.90...
-
Morgan Electronics Inc. is in the process of setting a selling price on a new CDL. component it has just developed. The following cost estimates for this component have been provided by the...
-
The adjustments columns of the worksheet for Munoz Company are shown below. Instructions (a) Prepare the adjusting entries. (b) Assuming the adjusted trial balance amount for each account is normal,...
-
Question 2 Mr. Marvin is a merchandising company which has business operations in Ipoh, Perak. The following trial balance has been extracted from the books as at 31 July 2021. Marvin Enterprise...
-
A house with a total living area of 2,500 square feet would cost $110 per square foot to reproduce new. It has an expected economic life of 50 years and is estimated to have an effective age of five...
-
1. Be able to provide an historical overview or discrimination against women in sport and recreation (e.g., child rearing practices & myths). 2. Enumerate and explain the legal entitlements of women...
-
Compare the process of budgeting revenues and expenses with the process of budgeting assets, liabilities, and owners equity, and explain how this information is included in the QuickBooks Accountant...
-
Describe the typical relationship between accumulated depreciation and depreciation expense and how this information is included in the QuickBooks Accountant budgeting process.
-
Explain how the Copy Across feature helps in creating QuickBooks Accountant budgets.
-
Explain how the Adjust Row Amounts feature helps in creating QuickBooks Accountant budgets.
-
Explain the typical relationship between sales and cost of goods sold, and describe how this information is included in the QuickBooks Accountant budgeting process.
-
Depletion Earth's Treasures Mining Co. acquired mineral rights for $24,000,000. The mineral deposit is estimated at 30,000,000 tons. During the current year, 6,300,000 tons were mined and sold. a....
-
What is your assessment of the negotiations process, given what you have studied? What are your recommendations for Mr. Reed? You must justify your conclusions
-
1. Why is there such an imbalance between supplier and retailer? 2. Given the obvious high price mark-up, on for example a pair of sports shoes, how justifiable are the claims made by the shoe...
-
1. Governments and educationalists generally regard it as desirable that trainees acquire transferable skills. Why may many employers disagree? 2. There are externalities (benefits) when employers...
-
1. How does the easy availability of credit affect the problem of inequality? 2. How might the actions of banks exacerbate the business cycle?
-
What is the taxable Social Security amount for Frank Schilling?
-
What is the amount of the credit to Social Security tax payable-OASDI?
-
What is the net income for the current month?
Study smarter with the SolutionInn App