Preview

Air Thread

Satisfactory Essays
Open Document
Open Document
1853 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Air Thread
A. How should the Cash Flows be valued for 2008-2012?
The calculation of each cash flow required us to use the projections from AirThread Connections that are given in the Exhibit 1 of the case allowing us to know the Total Revenue, EBITDA, EBIT and the Unlevered Net Income to be able to compute the Unleveraged Cash Flow (UFCF) from 2008-2012.
As well we used Depreciation & Amortization, Capital Expenditures and the assumptions established in AirThread Connections Exhibit 1 case to make the adjustments that Working Capital needed to fully calculate the Unleveraged Cash Flows from 2008 – 2012. Revenue Projections | | 2008 | 2009 | 2010 | 2011 | 2012 | Service Revenue | | 4,194.33 | 4,781.54 | 5,379.23 | 5,917.15 | 6,331.35 | Equipment Sales | | 314.77 | 358.84 | 403.70 | 444.07 | 475.15 | Total Revenue | | 4,509.10 | 5,140.38 | 5,782.93 | 6,361.22 | 6,806.50 | | System Operating Expenses | 838.87 | 956.31 | 1,075.85 | 1,183.43 | 1,266.27 | Cost of Equipment Sold | | 755.46 | 861.22 | 968.87 | 1,065.76 | 1,140.36 | Selling, General & Administrative | 1,803.64 | 2,056.15 | 2,313.17 | 2,544.49 | 2,722.60 | EBITDA | | 1,111.14 | 1,266.70 | 1,425.04 | 1,567.54 | 1,677.27 | Depreciation & Amortization | 705.23 | 803.96 | 867.44 | 922.38 | 952.91 | EBIT | | 405.91 | 462.74 | 557.60 | 645.16 | 724.36 | Tax Rate | | 162.36 | 185.10 | 223.04 | 258.07 | 289.74 | Net Operating Profit After Tax | 243.55 | 277.64 | 334.56 | 387.10 | 434.62 | | | | | | | | | | | | | | | Working Capital | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | Accounts Receivable | 435.5 | 521.90 | 595.00 | 669.40 | 736.30 | 787.90 | Days Sales Equip. Rev. | 101.0 | 135.00 | 153.90 | 173.10 | 190.40 | 203.70 | Prepaid Expenses | 41.6 | 46.90 | 53.50 | 60.10 | 66.20 | 70.80 | Accounts Payable | 143.4 | 163.20 | 186.10 | 209.30 |
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Good Essays

    Homework Solutions: Spilker Et Al. Ch. 20
    • 1342 Words
    • 6 Pages

    Homework Solutions: Spilker Et Al. Ch. 20

    g. Following the format in Exhibit 20 -2, prepare a tax basis balance sheet for the…

    • 1342 Words
    • 6 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Ocean Carriers: Question to Consider (2015)
    • 264 Words
    • 1 Page

    Ocean Carriers: Question to Consider (2015)

    3) Using information in Exhibit 6, calculate the cash flows from the ship operations over…

    • 264 Words
    • 1 Page
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    boeing guideline
    • 305 Words
    • 2 Pages

    boeing guideline

    project. Based on the information released by Boeing, Exhibit 8 shows a detailed free cash flow…

    • 305 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    Finance
    • 1032 Words
    • 5 Pages

    Finance

    2. Also in Exhibit 1, compute net income/net revenue (sales) for each of the four years. Begin with 2009.…

    • 1032 Words
    • 5 Pages
    Good Essays
    Read More
  • Good Essays

    Analysis Of Form 10k
    • 1166 Words
    • 5 Pages

    Analysis Of Form 10k

    Analyzing the cash flow statement also aids in understanding the movement of capital in a particular period. Two methods of reviewing the cash flow statements are the direct and the indirect methods. The direct method gives condensed cash receipts and cash disbursement statements while the indirect method offers cash movements by fine-tuning the net incomes of items that affected the net income without tampering with the…

    • 1166 Words
    • 5 Pages
    Good Essays
    Read More
  • Good Essays

    Aff5040 Toturial Answer
    • 927 Words
    • 4 Pages

    Aff5040 Toturial Answer

    Chapter 3 of Gitman (2011) outlines several relevant aspects that are relevant to this exercise. Firstly, be sure that you clearly understand as per Gitman how Free Cash Flow is to be calculated. Gitman defines free cash flow as (This approach was discussed in Lecture 3). Operating cash flows (OCF) = EBIT x (1 – T) Free Cash Flows = EBIT x (1 – T) + depreciation - Net Current Asset Investment - Net Non-Current Asset Investment Where Net Current Asset Investment (NCAI) = change in current assets – (change in accounts payable+ accruals) Net non-current asset investments (NNCAI) = change in net non-current assets + depreciation NOTE: NCAI measures the net investment made in current (operating assets) e.g. inventories, accounts receivables etc. It represents the change in working capital but excludes any financing costs associated with short term debt in current liabilities. Some analysts also remove cash and marketable securities so as the figure remains as a pure change in working capital. Obviously to measure NCAI we are interested in the change in Net working capital from one period to the next. NNCAI measures the net investment made in non-current fixed and other assets of the firm (e.g. Plant and equipment, buildings etc) It can be measured as the change from one period to the next in net fixed (non-current assets) + depreciation.…

    • 927 Words
    • 4 Pages
    Good Essays
    Read More
  • Good Essays

    Generally Accepted Accounting Principles and Non-operating Value
    • 1343 Words
    • 5 Pages

    Generally Accepted Accounting Principles and Non-operating Value

    Based on the projected cash flow information provided in the case, what is the stand- alone value of AirThread? Show the cash flow forecasts, discount rate, and your valuation model. 
(Hint: pay attention to the Working Capital Assumptions provided in Ex 1. For example, Accounts Receivable 41.67× means on average it takes 41.67 days to receive payment from customers. )…

    • 1343 Words
    • 5 Pages
    Good Essays
    Read More
  • Powerful Essays

    Valuation of Air Thread Connections
    • 969 Words
    • 4 Pages

    Valuation of Air Thread Connections

    The valuation of Air Thread is intended to present to it's potential acquirer, American Cable Communication (ACC) for consultation on decision of acquisition purpose. According to the case study, American Cable communications is a large and healthy cable operator which provides the services and products that related to internet, video and landline telephony. The demand of the ACC is high in America as for instance, there are around 48.5 million households installed the ACC cable , 24.1 million people who subscribe to ACC video, 13.2 million people who are currenly using ACC internet and 4.6 million landline telephone. According to James(2011), wireless is trending and is the future of communication and people relies heavily on wireless connections nowadays. The research team highlighted a study of wireless communications market and concluded that this market is highly competitive but highly profitable, there is around two-thirds of all Americans households using a wifi service (Industry overview, 2012). The wireless connectivity is trending in America but ACC does not provide the wireless network which is a huge opportunity loss to gain profit. Therefore, acquisition of ATC become a good opportunity to stay competitive in the market because ATC is one of the largest regional wireless companies across in America. ATC wireless's network coverage is strong and it covers around 80 million people and the market region of ATC is huge, it offered service fore more than two hundreds markets in United States. The potential to be acquire Air Thread Communication be equipped to competed with three to five major competitors in each market and it rely on the price, service area size, call quality and customer service to be more competitive. There are some drawbacks side of the market for ATC such as the disadvantage of the operating cost and incapacity to bundle wireless service. The acquisition of ATC will allow ATC and ACC to benefit with the…

    • 969 Words
    • 4 Pages
    Powerful Essays
    Read More
  • Good Essays

    Accounting Principles
    • 823 Words
    • 4 Pages

    Accounting Principles

    Fixed assets are appeared in a balance sheet at historical cost less depreciation up and coming. Depreciation influences the carrying value of an asset on the balance sheet. The historical expense will rise to the carrying value just if there has been no change recorded in the value of the asset since acquisition. In this manner, the accounting report does not demonstrate genuine value of assets. Historical cost is reprimanded for its mistake since it may not reflect current market valuation.…

    • 823 Words
    • 4 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Blaine Kitchenware
    • 151 Words
    • 9 Pages

    Blaine Kitchenware

    Blaine Kitchenware, Inc.: Capital Structure Course in Strategic Finance University of Vienna, 2015 Mila Dineva, 1153546 Blaine Kitchenware, Inc. • • • • • founded in 1927, small appliances for kitchens Public company, mainly controlled by the family 10% of the $ 2.3 bill. market 1994 – IPO In the 90’s – moved its production abroad Financial figures • • • • Over-liquid and under-leveraged, no debt 2% sales growth 2003-2006 11% p.a. annual returns for shareholders 2004-2006 $53.6 mil.…

    • 151 Words
    • 9 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Business Strategic Administration of Operation , Information and Finance
    • 299 Words
    • 2 Pages

    Business Strategic Administration of Operation , Information and Finance

    Castle Nursing home senior member of the management team been asked to make a report of this project.…

    • 299 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    Stage 1 Google
    • 1204 Words
    • 5 Pages

    Stage 1 Google

    * Summary: Looking at Google’s financial information, it is obvious how much the Recession affected the powerful company. Google’s stocks suffered during the recession in 2008 at $307.65 a share but they managed to pull it back up to $619.98 a year later by introducing the all new web browser, Google Chrome, and their first smartphone called the G1 for T-Mobile. Their stock grew a little in value over the past three years and was at $707.38 on December 31st of 2012.…

    • 1204 Words
    • 5 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Balance Sheet
    • 255 Words
    • 2 Pages

    Balance Sheet

    Nguyen Bich Fitness Club has provided the following information that relates to their financial year ended June 30, 2011…

    • 255 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Aramit Group Financial Statement
    • 518 Words
    • 3 Pages

    Aramit Group Financial Statement

    KEY OPERATING AND FINANCIAL DATA OF LAST FIVE YEARS HAVE BEEN PRESENTED BELOW IN SUMMARIZED FORM…

    • 518 Words
    • 3 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Electronics Industry in India
    • 1403 Words
    • 6 Pages

    Electronics Industry in India

    company Profit & Loss | Rs. cr | Period and months | 2008/03 | 2007/03 | 2006/03 | 2005/03 | 2004/03 | | INCOME | | Net Operating Income | 1,547.07 | 1,219.69 | 945.63 | 828.51 | 589.89 | | | | EXPENSES | Material Consumption | 1,107.53 | 856.73 | 680.37 | 628.41 | 407.45 | |…

    • 1403 Words
    • 6 Pages
    Satisfactory Essays
    Read More