You are to conduct a financial planning exercise for Comcast Income Statement 2022 Sales Costs EBIT...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are to conduct a financial planning exercise for Comcast Income Statement 2022 Sales Costs EBIT Interest Expenses EBT Taxes (@21%) Net Income Dividends Comcast Balance Sheet 2022 Current Assets Capital Assets Total Assets 2022 121,427 98,316 23,111 Long Term Debt Non Debt Long Term Liabilities Long Term Liabilities Shareholders Equity Total Liabilities & Equity 3,896 19,215 4,359 5,370 4,741 2022 21,826 235,449 257,275 Short Term Debt 780 Non Debt Short Term Liabilities 25,469 Current Liabilities 26,249 106,066 43,413 149,479 81,627 257,275 The following assumptions seem reasonable for an initial planning exercise. Now, you want to conduct a sensitivity analysis where sales only grow at 3.50% per year. The following accounts will be treated as percents of sales; costs at 81% of sales, current assets at 18%, capital assets at 194%, and non debt short-term liabilities at 21%. For planning purposes freeze the following accounts at 2022 levels; interest expenses, short term debt, long-term debt, and non debt long-term liabilities. Maintain shares outstanding and dividends per share at their current levels, 4,220 shares and $1.06 respectively. Use the current 21% flat tax rate under the TC.JA as the rate that the firm will face. Assuming sales only grow at 3.50% per year, and maintaining the other assumptions, what will be the External New Funding Required in 2027? You are to conduct a financial planning exercise for Comcast Income Statement 2022 Sales Costs EBIT Interest Expenses EBT Taxes (@21%) Net Income Dividends Comcast Balance Sheet 2022 Current Assets Capital Assets Total Assets 2022 121,427 98,316 23,111 Long Term Debt Non Debt Long Term Liabilities Long Term Liabilities Shareholders Equity Total Liabilities & Equity 3,896 19,215 4,359 5,370 4,741 2022 21,826 235,449 257,275 Short Term Debt 780 Non Debt Short Term Liabilities 25,469 Current Liabilities 26,249 106,066 43,413 149,479 81,627 257,275 The following assumptions seem reasonable for an initial planning exercise. Now, you want to conduct a sensitivity analysis where sales only grow at 3.50% per year. The following accounts will be treated as percents of sales; costs at 81% of sales, current assets at 18%, capital assets at 194%, and non debt short-term liabilities at 21%. For planning purposes freeze the following accounts at 2022 levels; interest expenses, short term debt, long-term debt, and non debt long-term liabilities. Maintain shares outstanding and dividends per share at their current levels, 4,220 shares and $1.06 respectively. Use the current 21% flat tax rate under the TC.JA as the rate that the firm will face. Assuming sales only grow at 3.50% per year, and maintaining the other assumptions, what will be the External New Funding Required in 2027?
Expert Answer:
Answer rating: 100% (QA)
SOLUTION To calculate the External New Funding Required we need to project the Balance Sheet for 2027 based on the given assumptions and freeze certai... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
Forensic Psychology's Role in the Legal SystemResources PSYC Discussion Participation Scoring Guide . In this unit, you were introduced to forensic psychology as a subfield of psychology as well as...
-
Use the attached "words.txt" file to store the words along with their ranks in an AVL tree. Then provide the user the option to search for any word. If the word exists the program displays the rank...
-
Discuss the role of effective team leadership in organizations. How would an effective team leader handle conflict between an employee's goals and the team's goals? Compare and contrast formal and...
-
Using the data provided in BE19-21, determine the ending balance of the plan assets and indicate the funded status of the plan at the end of the year under U.S. GAAP. In BE19-21 Armando Hernandez...
-
Why is charge usually transferred by electrons rather than by protons?
-
Ginny is a sole proprietor. She wants to provide 60 percent of salary disability coverage to Joanna, her employee who is in a 35 percent combined tax bracket. Joanna's W-2 wages are $40,000 and...
-
Tools of environmental management need to be eco-efficient. What is ecoefficiency? What is an eco-efficient tool? Provide a critical analysis of the view that conventional life-cycle assessment is...
-
You are a new summer intern working for a major professional services firm. During your lunch break each day, you and a fellow intern, Bob, eat at a local sandwich shop. One day, Bobs girlfriend...
-
Stock buybacks are always going to be a dubious subject. Some will contend that it is an efficient practice for prudent balance sheet management. Others will argue that there is a better use of a...
-
For each of the following, identify which GAAP, if any, has been violated. 1. A customer called and made arrangements for Jay's Plumbing to provide $6,000 of services next month. Jay, the owner,...
-
New construction of a particular type of real estate generally does not occur Multiple choice question. unless current property values exceed construction costs until interest rates are low enough...
-
A developing science that deals with designing workplaces to promote safety and health. a. Title VII b. exclusive remedy c. collective bargaining agreement d. ergonomics e. wildcat
-
Consider the following pre-merger information about a bidding firm (firm B) and a target firm (firm T). Assume that both firms have no debt outstanding. Firm B has estimated that the value of the...
-
Explain what is meant by this statement: Our tax rates are progressive.
-
Indicate whether each of the following statements is true or false by writing T or F i n t he a nswer c olumn. Employees have no reasonable expectation of privacy while they are at work; hence,...
-
A strike without the unions consent. a. Title VII b. exclusive remedy c. collective bargaining agreement d. ergonomics e. wildcat
-
Conduct a Trend Analysis - thoughtfully prepare a Word document addressing the following: a. Compare percentages for each year/each company - Summarize in writing b. Note any changes from one year to...
-
Explain the differences and similarities between fringe benefits and salary as forms of compensation.
-
Kampfire, Inc., a very successful manufacturer of camping equipment, is considering going public next month to raise funds to help finance the company's future growth. The financial manager of...
-
W. F. Bailey Company had a quick ratio of 1.4, a current ratio of 3.0, an inventory turnover of five times, total current assets of $810,000, and cash and equivalents of $120,000 in 2012. If the cost...
-
Green Thumb Garden Centers sells 240,000 bags of lawn fertilizer annually. The optimal safety stock (which is on hand initially) is 1,200 bags. Each bag costs Green Thumb $4, inventory carrying costs...
-
Consider a single-degree-of-freedom system with Coulomb damping (which offers a constant friction force, \(F_{c}\) ). Derive an expression for the force transmissibility when the mass is subjected to...
-
Consider a single-degree-of-freedom system with Coulomb damping (which offers a constant friction force, \(F_{c}\) ). Derive expressions for the absolute and relative displacement transmissibilities...
-
When a washing machine, of mass \(200 \mathrm{~kg}\) and an unbalance \(0.02 \mathrm{~kg}\) - \(\mathrm{m}\), is mounted on an isolator, the isolator deflects by \(5 \mathrm{~mm}\) under the static...
Study smarter with the SolutionInn App