This is an individual assignment. Everyone needs to work on the firm that your team chooses [prefer simple business] for your industry analysis. Follow my class video, do the following: 1. compute your company's free cash flow for the past 3 years. This requires you to compute each of the components in the FCF. Compare your FCF for the most recent year to that reported from the barchart website. Are you close? Explain why you cannot get close to it. Note for MSFT that I did in class, deferred tax is a big deal, it may not be a problem for you. NOPAT = EBIT - tax. Either find the line for tax, or do tax = EBT-NI. Also check their cash flow statement and that should give you a clue of what to include. 2. do a free cash flow model to value your stock for next year. Is your price close to the current stock price? If not, what could be the reason? 3. do a sensitivity table by varying terminal growth g and the WACC. Upload your excel file with a sheet explaining your results. Always highlight what you want me to see please.

This is an individual assignment. Everyone needs to work on the firm that your team chooses [prefer simple business] for your industry analysis. Follow my class video, do the following: 1. compute your company's free cash flow for the past 3 years. This requires you to compute each of the components in the FCF. Compare your FCF for the most recent year to that reported from the barchart website. Are you close? Explain why you cannot get close to it. Note for MSFT that I did in class, deferred tax is a big deal, it may not be a problem for you. NOPAT = EBIT - tax. Either find the line for tax, or do tax = EBT-NI. Also check their cash flow statement and that should give you a clue of what to include. 2. do a free cash flow model to value your stock for next year. Is your price close to the current stock price? If not, what could be the reason? 3. do a sensitivity table by varying terminal growth g and the WACC. Upload your excel file with a sheet explaining your results. Always highlight what you want me to see please.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

ChapterMB: Model-building Problems

Section: Chapter Questions

Problem 15M

See similar textbooks

Similar questions

Michael Anderson is starting his computer programming business and has deposited in initial investment of $15,000 into the business cash account. Identify how the accounting equation will be affected.
I need help filling out the excel template with this given information. Kate has just completed her first year of Kate's Cards. She has been preparing monthly income statements and balance sheets, so she knows that her company has been profitable and that there is cash in the bank. She has not, however, prepared a statement of cash flows. Kate's provides you with the year-end income statement and balance sheet and asks that you construct an statement of cash flows for Kate's Cards.Additional information:1. There were no disposals of equipment during the year2. Dividends in the amount of $1,300 were paid in cash during the year.3. Prepaid expenses relate to operating expenses.Requireda. Construct an statement of cash flows for Kate's Cards for the year-ended August 31, 2019, using the indirect method. Hint: Since this was Kate's first year of operations, the beginning balance sheet account balances were zero.b. Construct an statement of cash flows for Kate's Cards for the year ended…
PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULASPLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULASPLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS (Not written.. please) Empresa Comercial El Europeo, S.A., hires you because of the "good" references of your professor of the Financial Administration course, because he wants to know how much and at what time your cash needs will be manifested in the following semester as of January 1st. For which he provides the following: Sales are made 25% cash and 75% on credit. Of the credit sales, 75% is collected one month after the sale, and the remaining 25% two months later.You buy in a given month what you expect to sell the following month. The material cost is 45% of sales. The supplier gives the conditions of 60% cash and the other 40% the month after the purchase.Provisional tax payments are calculated, considering 1.25% of each month's sales and are paid the month following the month of sale.It is desired to…
PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULASPLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULASPLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS (Not written.. please) Empresa Comercial El Europeo, S.A., hires you because of the "good" references of your professor of the Financial Administration course, because he wants to know how much and at what time your cash needs will be manifested in the following semester as of January 1st. For which he provides the following: Sales are made 25% cash and 75% on credit. Of the credit sales, 75% is collected one month after the sale, and the remaining 25% two months later.You buy in a given month what you expect to sell the following month. The material cost is 45% of sales. The supplier gives the conditions of 60% cash and the other 40% the month after the purchase.Provisional tax payments are calculated, considering 1.25% of each month's sales and are paid the month following the month of sale.It is desired to…
Imagine you are the finance manager of Al Mohsin Company. The company management feels that the cash management of the company should be made more effective. The following information from the company’s records is available to you: Business Studies Department, University of Technology & Applied Sciences (UTAS) Ministry of Manpower, Outcomes for the Assignment: Graduate Attributes Covered: Student ID : Name: Section No:1 Month Sales February 40,000 March 55,000 April 60,000 May 74,000 June 90,000 Additional Information Purchase Wages 20,000 7,000 14,000 8,000 28,000 9,000 30,000 9,000 32,000 8,800 Miscellaneous expenses 1,000 3,000 2,000 2,000 3,500 1. Al Mohsin LLC expects to have RO 8,000 cash balance at the beginning of April. 2. Period of credit allowed by suppliers – 2 months 3. 40% of the total sale is for cash. Half of the credit sale is collected in the next month of sale and the remaining half in the following month after that. 4. Delay…
You have joined the companies finance team couple of months ago and went through a series of on job rotation and training. Today, the team welcomes a new member and your supervisor asks you take care of the new employee’s onboarding to the team. In particular, your supervisor asks you to tackle the following issues: 1. Describe the cash flows between a firm and its stakeholders. 2. The three fundamental decisions the finance team is concerned with, and how do they affect the firm’s balance sheet? 3. Explain why profit maximization is not the best goal for a company. What is an appropriate goal? 4. What are some of the external and internal factors that affect a firm’s stock price? What is the difference between these two types of factors? 5. Identify the sources of agency costs. What are some ways a company can control these costs? 6. Give an example of a conflict of interest in a business setting, other than the one involving the real estate agent discussed in the text.
A group of undergraduates has raised and spent $5 million developing a business thus far. Another $1 million has to be spent to finish the business. Once the business is fully developed, the group could sell the business for $3 million. In considering whether or not proceeding with the business is going to be profitable, which amounts of money are relevant? Selected answer will be automatically saved. For keyboard navigation, press up/down arrow keys to select an answer. a b C The $1 million cost to finish the business d The $3 million value of the finished business The $1 million cost to finish the business and the $3 million value of the finished business The $5 million already invested in developing the business
PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULASPLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULASPLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS (Not written.. please) Empresa Comercial El Europeo, S.A., hires you because of the "good" references of your professor of the Financial Administration course, because he wants to know how much and at what time your cash needs will be manifested in the following semester as of January 1st. For which he provides the following: Sales are made 25% cash and 75% on credit. Of the credit sales, 75% is collected one month after the sale, and the remaining 25% two months later.You buy in a given month what you expect to sell the following month. The material cost is 45% of sales. The supplier gives the conditions of 60% cash and the other 40% the month after the purchase.Provisional tax payments are calculated, considering 1.25% of each month's sales and are paid the month following the month of sale.It is desired to…
Matthew Mulatto and his brother John Mulatto plans to open a business. The major decision they face is how to organize the business. They expect to generate a massive profit during the first year. Although they have enough to start the business now as a partnership, they believe cash flow may be an issue as they grow. They believe that the corporate form of operation will be best option. They have hired you as a consultant and seek your advice. Requirements: 1. Answer the following questions for the Mulatto brothers. a) How are paid-in-capital and retained earnings: - Similar? - Different? b) What are the main categories of paid-in capital? c) When does a company declare a cash dividend? d) Which characteristic of a corporation limits a stockholder's loss to the amount of his or her investment in the stock of the corporation? e) What does the term par value of stock mean?
Matthew Mulatto and his brother John Mulatto plans to open a business. The major decision they face is how to organize the business. They expect to generate a massive profit during the first year. Although they have enough to start the business now as a partnership, they believe cash flow may be an issue as they grow. They believe that the corporate form of operation will be best option. They have hired you as a consultant and seek your advice. Requirements: 1. Answer the following questions for the Mulatto brothers. a. How are paid-in-capital and retained earnings: Similar? Different? b. What are the main categories of paid-in capital? c. When does a company declare a cash dividend? d. Which characteristic of a corporation limits a stockholder's loss to the amount of his or her investment in the stock of the corporation? e. What does the term par value of stock mean? 2. The owners are desirous of comparing serval financial transactions and possible outcomes to assist in guiding…
Your friends were excited to hear you have chosen accounting for a career. They have several practical questions regarding money and interest (time value of money). Please assist your friends by answering their respective questions. For each question: A. Estimate without using a table, calculator, etc. B. Document the "step-by-step" detail showing them how you solved the question. NOTE: To solve use one of the following: • EXCEL Include all the detail steps for whichever tool you choose. For example, if using EXCEL show all formulas (copy so reader could duplicate your work). If using a business calculator, in detail in proper order show numbers and buttons you input to obtain your answer. C. Provide a one to three sentence written explanation to your friend explaining the basic time value of money concept(s) impacting the solution. Friend #1 – Car Loan – What will by my monthly payment if I purchase a used car for $8,500? The dealer has offered to finance the purchase (car loan) over…
Your friends were excited to hear you have chosen accounting for a career. They have several practical questions regarding money and interest (time value of money). Please assist your friends by answering their respective questions. For each question: Estimate without using a table, calculator, etc. Document the “step-by-step” detail showing them how you solved the question. NOTE: To solve use one of the following: EXCEL Include all the detail steps for whichever tool you choose. For example, if using EXCEL show all formulas (copy so reader could duplicate your work). If using a business calculator, in detail in proper order show numbers and buttons you input to obtain your answer. Provide a one to three sentence written explanation to your friend explaining the basic time value of money concept(s) impacting the solution. Problems start with “Friend #1” at the top of page 2.