Problem I (20 points): Given the assumptions from 2013 to 2015, please assume that the financial...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Problem I (20 points): Given the assumptions from 2013 to 2015, please assume that the financial ratios in 2016 is the average of those of the first three years, answer the following questions. (Note: Try to give formulas you use or the calculating procedure to justify your answers.) 1) Using the method we learned in class, fill the following assumption form as well as Pro Forma financial statements of firm WNS for 2016. (15 points) 2) Compute the CFFA for firm WNS in 2016. (5 points) + Projection Assumptions (K) Sales Cost of goods sold ratio Operating expenses ratio Tax Rate Deprecation Interest (to be )paid Cash/Sales Days' sales in receivables Days' sales in inventory Net Fixed Asset Turnover Days to pay payables Other current liabilities/Sales Ending inventory Net Fixed Asset Net working capital 2013 100.00% 75.2% 21.30% 0.35 10 5 1% 43.4 59.4 12.5 10 1.50% N/a N/a N/a 2014 100.00% 75% 20.60% 0.35 10 5 1% 43.4 59.4 12.5 10 1.50% N/a N/a N/a 2015 100.00% 75.8% 20.30% 0.35 10 5 1% 43.4 59.4 12.5 10 1.50% 587 410 1100 2016 100.00% = - = = = Pro Forma Income Statement, WNS 2016 Sales Cost of Goods Sold Gross Profit Operating Expense Depreciation EBIT Interest EBT Tax Net Income Part of Pro Forma Balance Sheet, WNS 2016 Cash Accounts Receivable Inventory Current Assets Net Fixed Assets Accounts Payable Other current liabilities Current Liability 5500 Problem I (20 points): Given the assumptions from 2013 to 2015, please assume that the financial ratios in 2016 is the average of those of the first three years, answer the following questions. (Note: Try to give formulas you use or the calculating procedure to justify your answers.) 1) Using the method we learned in class, fill the following assumption form as well as Pro Forma financial statements of firm WNS for 2016. (15 points) 2) Compute the CFFA for firm WNS in 2016. (5 points) + Projection Assumptions (K) Sales Cost of goods sold ratio Operating expenses ratio Tax Rate Deprecation Interest (to be )paid Cash/Sales Days' sales in receivables Days' sales in inventory Net Fixed Asset Turnover Days to pay payables Other current liabilities/Sales Ending inventory Net Fixed Asset Net working capital 2013 100.00% 75.2% 21.30% 0.35 10 5 1% 43.4 59.4 12.5 10 1.50% N/a N/a N/a 2014 100.00% 75% 20.60% 0.35 10 5 1% 43.4 59.4 12.5 10 1.50% N/a N/a N/a 2015 100.00% 75.8% 20.30% 0.35 10 5 1% 43.4 59.4 12.5 10 1.50% 587 410 1100 2016 100.00% = - = = = Pro Forma Income Statement, WNS 2016 Sales Cost of Goods Sold Gross Profit Operating Expense Depreciation EBIT Interest EBT Tax Net Income Part of Pro Forma Balance Sheet, WNS 2016 Cash Accounts Receivable Inventory Current Assets Net Fixed Assets Accounts Payable Other current liabilities Current Liability 5500
Expert Answer:
Answer rating: 100% (QA)
Sales Cost of goods sold ratio Operating expenses ratio Tax Rate Depreciation Interest to be paid Ca... View the full answer
Related Book For
Fundamentals of Corporate Finance
ISBN: 978-1118845899
3rd edition
Authors: Robert Parrino, David S. Kidwell, Thomas W. Bates
Posted Date:
Students also viewed these finance questions
-
Determine the regression equation Negative amounts should be indicated by a minus sign Round your answers to 3 decimal places X Y Picture Picture Picture 2 Picture 2 Picture Picture 5 13 2375 5641 3...
-
How does the pretax operating cash flow for a project differ from the economic profit for that project?
-
Dallas Corporation reports the following amounts for Years 1 and 2: Each tax year is a 12-month period. Dallas qualifies as a small corporation for purposes of estimated tax payments, but it does not...
-
You accepted a new job with starting salary of $52,000 per year. The salary is expected to increase 4% each year. Now it is time to make a retirement plan for the next 39 years you expect to work....
-
Answer the following questions using the data from the Excel file daily customers. xlsx described in Problem 16.38: a. Forecast the number of customers who will visit Daves store on Day 9 using a two...
-
Determine the frontier portfolio \(w^{*}\) such that its variance is equal to the variance of its zero correlation portfolio, i.e., determine the frontier portfolio \(w^{*}\) such that...
-
What are some incentives or pressures to misappropriate assets?
-
AnimPix, Inc., is a small company that creates computer-generated animations for films and television. Much of the company's work consists of short commercials for television, but the company also...
-
Matt Phone Store had net credit sales of RM8,500,000 and cost of goods sold of RM5,000,000 for the year. The Accounts Receivable balances at the beginning and end of the year were RM600,000 and...
-
Antelopes, native to Africa and Asia, range in size from 30 cm to over 180 cm at the shoulder, with most between 90-120 cm. This is related to the humerus length. The data below gives the length and...
-
Use sales data below, Sale Occurred/100 calls 14 23 18 26 25 28 24 25 23 21 22 26 17 17 23 25 24 19 28 21 19 23 20 24 32 22 31 21 25 20 19 23 22 22 20 16 25 18 27 20 25 14 11 22 28 21 18 28 21 20 21...
-
(b) Sodium chloride is an ionic compound with the chemical formula NaCl. (i) Give the electron configurations of sodium (Na) and chlorine (Cl) using spdf notation. [2 marks] (ii) Use electron...
-
Motor grader with a diesel engine of 180 HP has an initial cost of 594,000. Its estimated useful life is 6 years and it is anticipated that it will be used an average of 2,000 hours per year. The...
-
Tano Company issues bonds with a par value of $85,000 on January 1, 2021. The bonds' annual contract rate is 8%, and interest is paid semiannually on June 30 and December 31. The bonds mature in...
-
You will write a program to create an airline reservation system for a small airline. You are to write a program to assign seats for a flight with a capacity of 10. (Assume 1 seat per row) Your...
-
Diagon Alley Magic Company Ltd On February 9, 2021, Harry Potter, Materials Manager at Diagon Alley Magic Company Ltd in Diagon Alley UK, was preparing for the next continuous improvement team...
-
I am stuck on tha last one plz help To calculate the after-tax cost of debt, multiply the before-tax cost of debt by \( (1-1) abla \). Perpetualcold Refrigeration Company (PRC) can borrow funds at an...
-
The rate at which the temperature of an object changes is proportional to the difference between its own temperature and the temperature of the surrounding medium. Express this rate as a function of...
-
Abacus Corporation will pay dividends of $2.25, $2.95, and $3.15in the next three years. After three years, the dividends are expected to grow at a constant rate of 4 percent per year. If the...
-
Kelly Martin has $10,000 that she can deposit into a savings account for five years. Bank A pays compounds interest annually, Bank B twice a year, and Bank C quarterly. Each bank has a stated...
-
Sunny Way Landscaping has a formal line of credit of $500,000 with First Commerce Bank. The interest rate on the loan is 6 percent, and under the agreement, Sunny Skies must pay an annual fee of 75...
-
For the flow in Problem 7, write the boundary conditions for pressure when the flow is incompressible and inviscid and there is no body force.
-
If your course involves exercises with a CFD code, study the manual to determine which of the projection schemes discussed in Section 10.4 (SIMPLE, SIMPLEC, SIMPLER, PISO) are implemented. Are there...
-
Does the steady-state formulation of a CFD problem make sense in DNS, LES, or RANS?
Study smarter with the SolutionInn App