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. Itschief 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.)1 Cash2 Accounts receivable3 Inventory4 Accounts payableYear 1619617Year 21123822Year 314261123The cash flow associated with the change in working capital for year 1 is $ million. (Round to the nearest integer.)Year 45242151427Year 5162414९34Assuming 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 thisinvestment. (Enter increases as negative numbers since they are uses of cash.)

Working capital refers to the funds that a company has available for its daily operations. It…

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 3 117 14 26 11 23 1 Cash 2 Accounts receivable 3 Inventory 4 Accounts payable Year 1 6 19 6 17 Year 2 11 23 8 Year 4 22 15 24 14 Year 5 16 24 14 27 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.) 34 D

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 3 117 14 26 11 23 1 Cash 2 Accounts receivable 3 Inventory 4 Accounts payable Year 1 6 19 6 17 Year 2 11 23 8 Year 4 22 15 24 14 Year 5 16 24 14 27 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.) 34 D

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Castle View Games would like to invest in a division to develop software for a soon- to-be-released video game console. To evaluate this decision, the firm firstattempts to project the working capital needs for this operation. Its chief financial officer has developed the following estimates (in millions of dollars): Year 1 Year 2 Year 3 Year 4 Year 5 Cash 6. 12 15 15 15 Accounts receivable 21 22 24 24 24 Inventory Accounts payable 5 7 10 12 13 18 22 24 25 30 If Castle View currently does not have any initial working capital invested in this division, calculate the cash flows associated with changes in working capital for the first five years of this investment. 3.
3. 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.) 1 Cash 2 Accounts receivable 3 Inventory 4 Accounts payable Year 1 6 22 5 17 Year 2 12 26 9 22 Year 3 15 24 million. (Round to the nearest integer.) million. (Round to the nearest integer.) million. (Round to the nearest integer.) million. (Round to the nearest integer.) million. (Round to the nearest integer.) 11 24 Year 4 16 22 13 28 Year 5 14 25 16 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…
For example, if you a simple average of 5 year of either income or cash flow of:year 1 100year2 100year 3 100year 4 100year 5 100total 500average 100cap rate 0.2value 500 Now you go to the balance sheet as of the valuation date and have a cash balance of $500 and the industry working capital benchmark is $200, is it fair to add $300 to the value of the business? That is really the question. In practice, particularly matrimonial valuations, some practitioners would opine, if the owner sells the business they would realize $500 in value plus $300 in excess working capital for a total value of $800. Remember the value included the $300 ($100 each year), possibly not distributed cash flow/earnings, is that really value?
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…
Gamestop wants to invest in a new division to develop software for video games. The company is evaluating this decision by projecting the working capital needs for the operation. The CFO has developed the following estimates (in millions of dollars). Assume that Gamestop does not currently have any working capital invested in this division. Calculate the cash flows associated with the net working capital and changes in net working capital for the first five years of this investment. Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Cash 6. 12 16 15 14 Accounts 21 26 24 25 24 Receivable Inventory Accounts 5 10 12 15 17 19 25 25 32 Payable NWC ANWC
You must type in both the answer and all of your work to receive credit. Use the financial statements and additional data provided by management to calculate the firm's Free Cash Flow for the projected year. • Tax rate = 25% • Plans for the projected year will require $500 of new machinery and equipment • Firm expects next year's dividend to be $260 Acme Products, Inc. Balance Sheets ASSETS Cash Receivables Inventory Property, plant & equipment Total assets LIABILITIES & EQUITY Accounts payables Accrued expenses Long-term debt Common stock Paid-in Capital Retained earnings Total liabilities and equity current yr 400 600 900 2,200 4,100 500 400 1,400 600 200 1,000 4,100 projected yr 500 750 1,125 2,750 Acme Products, Inc. Income Statement Operating expenses 5,125 Depreciation 5,125 Sales (all credit) Cost of Goods Sold Gross Profit Operating income Interest expense 625 Taxable income 500 Taxes (25%) 1,750 Net income 750 250 1,250 projected yr 7,000 4,000 3,000 1,400 400 1,200 100 1,100…
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.
show what is the time value of money figures of the present and future value of Pepsi and Coca-Cola companies. Complete the calculations on the Time Value of Money tab Spreadsheet. Explain your justifications. Specifically, the following critical elements must be addressed: 1) Time Value of Money Using Spreadsheet, calculate the following time value of money figures: A) Calculate the present value of your selected company based on the given of 5% interest rate and free cash flows for the latest three fiscal or calendar year-end values. Suppose the risk of your selected company were to change. This change is based on an unanticipated decrease of 10% annually in the free cash flows during the latest three fiscal or calendar year-end values you entered into the Final Project Spreadsheet. Recalculate the present value of the company. Suppose that a potential buyer has offered to buy your selected company in three years. Your selected company has projected that the free cash flows will…
Siap Sedia Bank Bhd is considering providing the following facilities to Kencana Berhad. Facilities Amount (RM) Overdraft 800,000 Letter of Credit 900,000 Term Financing 1,000,000 Explain TWO (2) Liquidity Ratios and THREE (3) Activity Ratios that can be used to assess the company’s financial standing. Describe THREE (3) security documents for Bai’ Bithaman Ajil (BBA) Home Financing.
In the provided scenario, you address the time value of money also known as discounted cash flow analysis. This type of analysis is crucial to being able to viably analyze financial statements. The start - up firm you founded is trying to save $10, 000 in order to buy a parcel of land for a proposed small warehouse expansion. In order to do so, your finance manager is authorized to make deposits of S 1250 per year into the company account that is paying 12% annual interest. The last deposit will be less than $1250 if less is needed to reach $10,000. How many years will it take to reach the $10,000 goal and how large will the last deposit be? Show your work
Hi, You have already solve a,b,and c. May I please have the solutions for the remining questions? Thanks Plastico, a manufacturer of consumer plastic products, is evaluating its capitalstructure. The balance sheet of the company is as follows (in millions):Assets LiabilitiesFixed assets $4,000 Debt $2,500Current assets $1,000 Equity $2,500In addition, you are provided the following information:• The debt is in the form of long-term bonds, with a coupon rate of 10%. The bondsare currently rated AA and are selling at a yield of 12% (the market value of the bonds is80% of the face value).• The firm currently has 50 million shares outstanding, and the current market priceis $80 per share. The firm pays a dividend of $4 per share and has a price/earnings ratioof 10.• The stock currently has a beta of 1.2. The riskfree rate is 8%.• The tax rate for this firm is 40% Plastico is considering a major change in its…
Create financial statements for a fitness online company that produces video programs for its members. Assume that an initial investment of $100,000 will be provided of which $50K is equity which allowed you to leverage $50K in debt. (Financial statements should be in a table format).