calculate the NWC for the following Assumptions 8 5- File Home Insert Page Layout Formulas Data Review
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
8 5- File Home Insert Page Layout Formulas Data Review View Help 4267-XLS-ENG - Excel Tell me what you want to do Sabrina Ram SR ✗Cut Times New Roma 8 - Α' Α' ab Wrap Text Σ Autosum Custom 田 Copy ▼ ✓ Fill▾ Paste Format Painter BIU 7 Merge & Center % +.0 .00 Conditional Format as Cell Insert Delete Format Verkleinern P Sort & Find & Formatting Clipboard > Font Alignment Number ☑ Table▾ Styles▾ Styles Clear ▾ Filter▾ Select Cells Editing E77 fx A B C D E F G H I J K L M N P Q R S т U V W 55 56 57 58 Revenue Projections: 59 Service Revenue 2008 2009 4.194,3 4.781,5 2010 5.379,2 2011 5.917,2 2012 6.331,4 60 Plus: Equipment Revenue 314,8 61 Plus: Synergy Related Revenue 0,0 62 Total Revenue 4.509,1 358,8 0,0 5.140,4 403,7 0,0 5.782,9 63 Less: System Operating Expenses 838,9 956,3 64 Plus: Backhaul Synergie 0,0 0,0 65 Less: Cost of Equipment Sold 66 Less: Selling, General & Administrative 67 EBITDA 68 Less: Depreciation & Amortization 755,5 861,2 1.075,8 0,0 968,9 1.803,6 2.056,2 2.313,2 444,1 0,0 6.361,2 1.183,4 0,0 1.065,8 2.544,5 475,2 0,0 6.806,5 1.266,3 0,0 1.140,4 2.722,6 69 EBIT 1.111,1 1.266,7 1.425,0 705,2 804,0 405,9 1.567,5 1.677,3 867,4 922,4 952,9 462,7 557,6 645,2 724,4 162,4 185,1 223,0 258,1 289,7 70 Taxes 71 EBIAT 72 Plus: Depreciation & Amortization 73 Less: Changes in Working Capital 74 Less: Capital Expenditures 243,55 277,64 334,56 387,10 434,62 705,23 803,96 867,44 922,38 952,91 631,27 719,65 867,44 970,09 1.055,01 75 Unlevered Free Cash Flow 76 77 Working Capital Assumptions (1): 78 Accounts Receivable 41,67x 79 Days Sales Equip. Rev. 154,36x 80 Prepaid Expenses 81 Accounts Payable 41,67x 41,67x 41,67x 41,67x 154,36x 154,36x 154,36x 154,36x 1,38% 1,38% 1,38% 1,38% 1,38% 35,54x 35,54x 35,54x 35,54x 82 Deferred Serv. Revenue 6,85x 6,85x 14,01x 14,01x 14,01x 14,01x 6,85x 35,54x 14,01x 6,85x 6,85% Exhibit 1 (2) WACC Exhibit 1 Exhibit 2 Exhibit 3 Exhibit 4 Exhibit 5 Exhibit 6 Exhibit 7 83 Accrued Liabilities 84 85 Canital Expenditures (2)· Ready H Zur Suche Text hier eingeben + 100% 18:35 × DEU 09.03.2021 8 5- File Home Insert Page Layout Formulas Data Review View Help 4267-XLS-ENG - Excel Tell me what you want to do Sabrina Ram SR ✗Cut Times New Roma 8 - Α' Α' ab Wrap Text Σ Autosum Custom 田 Copy ▼ ✓ Fill▾ Paste Format Painter BIU 7 Merge & Center % +.0 .00 Conditional Format as Cell Insert Delete Format Verkleinern P Sort & Find & Formatting Clipboard > Font Alignment Number ☑ Table▾ Styles▾ Styles Clear ▾ Filter▾ Select Cells Editing E77 fx A B C D E F G H I J K L M N P Q R S т U V W 55 56 57 58 Revenue Projections: 59 Service Revenue 2008 2009 4.194,3 4.781,5 2010 5.379,2 2011 5.917,2 2012 6.331,4 60 Plus: Equipment Revenue 314,8 61 Plus: Synergy Related Revenue 0,0 62 Total Revenue 4.509,1 358,8 0,0 5.140,4 403,7 0,0 5.782,9 63 Less: System Operating Expenses 838,9 956,3 64 Plus: Backhaul Synergie 0,0 0,0 65 Less: Cost of Equipment Sold 66 Less: Selling, General & Administrative 67 EBITDA 68 Less: Depreciation & Amortization 755,5 861,2 1.075,8 0,0 968,9 1.803,6 2.056,2 2.313,2 444,1 0,0 6.361,2 1.183,4 0,0 1.065,8 2.544,5 475,2 0,0 6.806,5 1.266,3 0,0 1.140,4 2.722,6 69 EBIT 1.111,1 1.266,7 1.425,0 705,2 804,0 405,9 1.567,5 1.677,3 867,4 922,4 952,9 462,7 557,6 645,2 724,4 162,4 185,1 223,0 258,1 289,7 70 Taxes 71 EBIAT 72 Plus: Depreciation & Amortization 73 Less: Changes in Working Capital 74 Less: Capital Expenditures 243,55 277,64 334,56 387,10 434,62 705,23 803,96 867,44 922,38 952,91 631,27 719,65 867,44 970,09 1.055,01 75 Unlevered Free Cash Flow 76 77 Working Capital Assumptions (1): 78 Accounts Receivable 41,67x 79 Days Sales Equip. Rev. 154,36x 80 Prepaid Expenses 81 Accounts Payable 41,67x 41,67x 41,67x 41,67x 154,36x 154,36x 154,36x 154,36x 1,38% 1,38% 1,38% 1,38% 1,38% 35,54x 35,54x 35,54x 35,54x 82 Deferred Serv. Revenue 6,85x 6,85x 14,01x 14,01x 14,01x 14,01x 6,85x 35,54x 14,01x 6,85x 6,85% Exhibit 1 (2) WACC Exhibit 1 Exhibit 2 Exhibit 3 Exhibit 4 Exhibit 5 Exhibit 6 Exhibit 7 83 Accrued Liabilities 84 85 Canital Expenditures (2)· Ready H Zur Suche Text hier eingeben + 100% 18:35 × DEU 09.03.2021
Expert Answer:
Answer rating: 100% (QA)
To calculate the Net Working Capital NWC based on the given assumptions we will nee... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these finance questions
-
A government agency pays research contractors a fee to cover overhead costs, over and above the direct costs of a research project. Although overhead costs vary considerably among contracts, they are...
-
Find a formula for the function 9(2) as a transformation of the function f(x). -3-2-1 0 x 23 -1 0 1 2 3 4 5 -690 6 -3 -12 g(x) 3 f(x)-1 1 2 -30-214
-
Imagine you are Staffing the HR Department and assessing the work design present in your selected Apple Company when you realize that you have not adequately reviewed the job descriptions,...
-
Penny Stafford, the owner of Belvi Coffee and Tea Exchange, located in Bellevue, Washington, brought an antitrust suit against Starbucks. She alleged that through its exclusive leases, Starbucks bans...
-
What is the payback period for the project described below? Machine investment MARR Annual benefit $24,999 10% $6,500 Annual maintenance $2,000 Life 10 years Salvage value $2,000
-
Refer to the information in Exercise 10-4. Prepare a table showing depreciation and book value for each of the four years assuming double-declining-balance depreciation.
-
Suppose Union University has spent $10,000 on an option to purchase land for new dormitories at a price of $100,000. Also assume that it is later offered an equally attractive site for $95,000. What...
-
Tea has been in the limelight recently thanks to increasing global demand, especially in emerging economies like China and India. China, India, Kenya, and Sri Lanka are some of the largest producers...
-
Microwave ovens rotate at a rate of about 5.2 rev/min. A)What is this in revolutions per second? B)what is the angular velocity of this microwave in radians per second
-
Create a test() function that takes an array as input and returns the minimum value, maximum value, mean, median, mode, standard deviation, variance, Quartile1, Quartile3, and Quartile deviation of...
-
Absa Bank loaned Striped Enterprises money at 7% interest for 120 days. If the amount of interest was R3500, use the ordinary interest method to find the amount of principal borrowed. Mike Johnson...
-
Consider the scenario below where the square is representing a frame. You are processing an image where every object will be shown within the frame. Using Cohen- Sutherland line clipping algorithm,...
-
The company accrues $ 3 0 , 0 0 0 of payroll on Wednesday which will be payable on Friday. Income tax withholding is 5 % of payroll, assume standard Social Security and Medicare rates with no...
-
The following data for November have been provided by Hunn Corporation, a producer of precision drills for oil exploration: Budgeted production 5 , 0 0 0 drills Standard machine - hours per drill 1 0...
-
Evaluate the indefinite integral by parts. Jx cos 9x dx cos 9x + sin 9x +C 1 san 9x + conx+C 81 O ootion2 option cor 9+in + con 81 a 9x + sin. 9 +
-
In exchange for land, the company received a 12-month note on January 1. The face amount of the note is $1,000, and the stated rate of interest is 13%, compounded annually. The 13% rate is equal to...
-
On February 2, 2012, Alexandra purchases a personal computer for her home. The computer cost $3,000. Alexandra uses the computer 80 percent of the time in her accounting business, 10 percent of the...
-
John Williams (age 42) is a single taxpayer, and he lives at 1324 Forest Dr., Reno, NV 89501. His Social Security number is 555-94-9358. John's earnings and withholdings as the manager of a local...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Two loudspeakers \(42.0 \mathrm{~m}\) apart and facing each other emit identical \(115 \mathrm{~Hz}\) sinusoidal sound waves in a room where the sound speed is \(345 \mathrm{~m} / \mathrm{s}\). Susan...
-
A child's train whistle replicates a classic conductor's whistle from the early 1900 s. This whistle has two open-open tubes that produce two different frequencies. When you hear these two different...
-
A student waiting at a stoplight notices that her turn signal, which has a period of \(0.85 \mathrm{~s}\), makes one blink exactly in sync with the turn signal of the car in front of her. The blinker...
Accounting Ledger Book With Yearly Financial Planning And Notes Pages - ISBN: B0CDYRLTN6 - Free Book
Study smarter with the SolutionInn App