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

  • Satisfactory Essays

    MODULE 4 EXAM LK 2014 11 8
    • 618 Words
    • 6 Pages

    MODULE 4 EXAM LK 2014 11 8

    On the basis of the following data for Seller Co. for 2008 and the preceding year ended December 31, 2007, prepare a statement of cash flows. Use the indirect method of reporting cash flows from operating activities. Assume that equipment costing $125,000 was purchased for cash and equipment costing $85,000 with accumulated depreciation of $65,000 was sold for $15,000; that the stock was issued for cash; and that the only entries in the retained earnings account were net income of $51,000 and cash dividends declared of $13,000.…

    • 618 Words
    • 6 Pages
    Satisfactory Essays
    Read More
  • 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
  • Good Essays

    Acct. 551 Final Project
    • 1065 Words
    • 5 Pages

    Acct. 551 Final Project

    All property, plant, and equipment for the parent and subsidiary companies are recorded at historical cost. The method of depreciation for each asset is determined according to current accounting rules and regulations as set forth by GAAP. All amortization, including the amortization of intangible assets, is on a straight-line basis over the estimated life of the intangible asset. All useful asset lives for amortization and depreciation have been estimated as accurately as possible. Any changes that occur in estimations are thoroughly noted and accounted for in the respective period when it is determined that the useful life should be changed.…

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

    Short Term 531 Week 1 Quiz
    • 2106 Words
    • 9 Pages

    Short Term 531 Week 1 Quiz

    No cash accounting transactions are ignored.\ Which of the following is an Assumption of financial statements? Perodicity, Going Concern, Accrual Basis\ principle dictates that companies record assets at their historical cost principle dictates that companies record assets at their historical cost\ The materiality constraint Relates to a financial statement item's impact on a company's overall financial condition and operations. Size is a big factor.\ Revenues - COGS - Admin Expense = Earnings\ Cash + Inventory + A/R = Current Assets\ Accounts Payable + Short term N/P = Current Liabilities\ Working Capital = current assets – current liabilities\ Net Operating Working Capital = Current assets - Current liabilities - Notes Payable\ Net Operating Working Capital takes into consideration the interest bearing loans. Notes paying interest also have an impact on the financial statements and company performance because of the interest costs. NOWC show what would be leftover to operating with if these loans were paid.\ Earnings…

    • 2106 Words
    • 9 Pages
    Powerful 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
  • 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
  • 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
  • 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
  • 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
  • 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

    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

Related Topics