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.

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

Lana Powell is seeking part-time employment while she teaches school. She is considering purchasing technical equipment that will enable her to start a small training services company that will offer tutorial services over the internet. Lana expects demand for the service to grow rapidly in the first two years of operation as customers learn about the availability of the Internet assistance. Thereafter, she expects demand to stabilize. The following table presents the expected cash flows. Year of Operation Cash Inflow 2010 $6,500 4,500 7,000 7,000 In addition to these cash flows, Ms Powell expects to pay $7,300 for the equipment. She also expects to pay $1,200 for a major overhaul and updating of the equipment at the end of the second year of operation. The equipment is expected to have a $750 salvage value and a four-year useful life. Ms Powell desires to earn a rate of return of 10 percent. What is the Net Present Value of the investment opportunity? (Round computations to the…
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 answer requirement 2. part a and b. Thank you.
You are a Corporate Credit Analyst for your bank. A new corporate customer in the manufacturing sector approached your bank for a large credit facility in the sum of $20 million for production equipment and warehousing. The customer submitted the following financials to you. The cash position increased from $6.7 million in 2019 to $16 million in 2021. Does this signal a strengthening of the liquidity position of the firm? Explain.
Kate is considering expanding and bringing in several employees. To do this she will need a larger facility and to purchase more equipment. Which means additional financing. Answer this: look at the financial statements as if you were a banker considering her for a loan comment on your findings and use calculations to support your answer.
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
Suppose you are the only owner of a chain of coffee shops near universities. Your current cafés are doing well, but you are interested in starting a fine-dining restaurant. You decide to use the cash generated from your existing business to enter into a new business. Your accountant provides you with the following data on your current financial performance: Financial update as of June 15 • Your existing business generates $123,000 in EBIT. • The corporate tax rate applicable to your business is 25%. • The depreciation expense reported in the financial statements is $23,429. • You don’t need to spend any money for new equipment in your existing cafés; however, you do need $18,450 of additional cash. • You also need to purchase $9,840 in additional supplies—such as tableclothes and napkins, and more formal tableware—on credit. • It is also estimated that your accruals, including taxes and wages…
Kampfire, Inc., a very successful manufacturer of camping equipment, is considering going public next month to raise funds to help finance the company’s futuregrowth. The financial manager of Kampfire has approached the investmentbanking firm at which you work seeking help with its decision. Your boss askedyou to explain the nature of the U.S. financial markets and the process of issuingequity to the financial manager. To help with this task, your boss has asked youto answer the following questions in explaining the U.S. financial system to thefinancial manager:a. What is a financial market? How are financial markets differentiated frommarkets for physical assets?b. Differentiate between money markets and capital markets.c. Differentiate between a primary market and a secondary market. If Microsoftdecided to issue additional common stock and an investor purchased 1,000shares of this stock from the underwriter, would this transaction be a primarymarket transaction or a secondary market…
Seeing your success, one of your friends, Greg Kommens, opened a cinnamon roll shop. He wants to buy one of your mixers, but he cannot afford to pay for the mixer for 30 days. Greg gave you a set of his most recent financial statements. What calculations should you make with the data from these statements, and what questions should you ask him after you have analyzed the statements? How will this information help you decide if you should extend credit to Greg?” Is there an alternative other than extending credit to Greg for 30 days?” “You are thinking seriously about being able to have your customers use credit cards. What are some of the advantages and disadvantages of letting your customers pay by credit card?” The following transactions occurred in June through August 2021. June 1 After much thought, you sell a mixer to Greg on credit, terms n/30, for $985 (cost of mixer $510). 30 Greg calls you. He is unable to pay the amount outstanding for…
Assume that you graduated from college with a major in finance and took a job with a large bank. After 3 years, you are laid off when the company downsizes. Describe the steps you’d take to “repackage” yourself for another field.
Royal Mount Games would like to invest in a division to develop software for video games. To evaluate this decision, the firm first attempts to project the working capital needs for this operation. Its chief financial officer has developed the following estimates (in millions of dollars): (To copy the table below and use in Excel, click on icon in the upper right corner of table.) Year 1 Year 2 Year 3 Year 4 Year 5 1 Cash 5 12 14 16 14 2 Accounts receivable 18 22 23 21 25 3 Inventory 4 9 10 14 15 4 Accounts payable 17 22 24 27 31 Assuming that Royal Mount currently does not have any working capital invested in this division, calculate the cash flows associated with changes in working capital for the first five years of this investment. (Enter increases as negative numbers since they are uses of cash.) The cash flow associated with the change in working capital for year 1 is $ integer.) million. (Round to the nearest
Aaron Heath is seeking part-time employment while he attends school. He is considering purchasing technical equipment that will enable him to start a small training services company that will offer tutorial services over the Internet. Aaron expects demand for the service to grow rapidly in the first two years of operation as customers learn about the availability of the Internet assistance. Thereafter, he expects demand to stabilize. The following table presents the expected cash flows: Year of Operation Year 1 Cash Inflow Cash Outflow $13,100 Year 2 19,200 Year 3 Year 4 22,000 22,000 $ 8,700 11,700 12,800 12,800 In addition to these cash flows, Aaron expects to pay $20,800 for the equipment. He also expects to pay $3,600 for a major overhaul and updating of the equipment at the end of the second year of operation. The equipment is expected to have a $1,500 salvage value and a four-year useful life. Aaron desires to earn a rate of return of 10 percent. (PV of $1 and PVA of $1) (Use…

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS