Question #1 Using Financial Ratios to Improve Working Capital AccountsBobs accountant found ways that ABC company could generate more cash by improving twoareas, Average Collection period and ABC's inventory turnover. With the following informaticcalculate how much cash ABC company could generate within the next six months if she wereable to improve her average collection period to 25 days and the inventory turnover to 5 times.Revenue: 1,750,000Cost of Sales 1,200,000Trade Receivables 192,000Inventories 250,000

Question #1 Using Financial Ratios to Inprove Working Capital Accounts Bobs accountant found ways that ABC company could generate more cash by improving tv areas, Average Collection period and ABC's inventory turnover. With the following informr calculate how much cash ABC company could generate within the next six months if she w able to improve her average collection period to 25 days and the inventory turnover to 5 tim Revenue: 1,750,000 Cost of Sales 1,200,000 Trade Receivables 192,000

Question #1 Using Financial Ratios to Inprove Working Capital Accounts Bobs accountant found ways that ABC company could generate more cash by improving tv areas, Average Collection period and ABC's inventory turnover. With the following informr calculate how much cash ABC company could generate within the next six months if she w able to improve her average collection period to 25 days and the inventory turnover to 5 tim Revenue: 1,750,000 Cost of Sales 1,200,000 Trade Receivables 192,000

Entrepreneurial Finance

6th Edition

ISBN:9781337635653

Author:Leach

Publisher:Leach

Chapter2: Developing The Business Idea

Section: Chapter Questions

Problem 9SEP

See similar textbooks

Similar questions

Financial leverage MicrosoCortrepotied (MSFT) reported the following data (in millions) for a tern year Compute the profit margin, asset turnover, and financial leverage metrics using the expandedDuPont formula. Round profit margin, asset turnover, and financial leverage to two decimalplaces.Round return on stockholders’ equity to one decimal place.
Sales Increase Maggies Muffins Bakery generated 5 million in sales during 2018, and its year-end total assets were 2.5 million. Also, at year-end 2018, current liabilities were 1 million, consisting of 300,000 of notes payable, 500,000 of accounts payable, and 200,000 of accruals. Looking ahead to 2019, the company estimates that its assets must increase at the same rate as sales, its spontaneous liabilities will increase at the same rate as sales, its profit margin will be 7%, and its payout ratio will be 80%. How large a sales increase can the company achieve without having to raise funds externallythat is, what is its self-supporting growth rate?
Forecasted Statements and Ratios Upton Computers makes bulk purchases of small computers, stocks them in conveniently located warehouses, ships them to its chain of retail stores, and has a staff to advise customers and help them set up their new computers. Uptons balance sheet as of December 31, 2018, is shown here (millions of dollars): Sales for 2018 were 350 million, and net income for the year was 10.5 million, so the firms profit margin was 3.0%. Upton paid dividends of 4.2 million to common stockholders, so its payout ratio was 40%. Its tax rate was 40%, and it operated at full capacity. Assume that all assets/sales ratios, (spontaneous liabilities)/sales ratios, the profit margin, and the payout ratio remain constant in 2019. a. If sales are projected to increase by 70 million, or 20%, during 2019, use the AFN equation to determine Uptons projected external capital requirements. b. Using the AFN equation, determine Uptons self-supporting growth rate. That is, what is the maximum growth rate the firm can achieve without having to employ nonspontaneous external funds? c. Use the forecasted financial statement method to forecast Uptons balance sheet for December 31, 2019. Assume that all additional external capital is raised as a line of credit at the end of the year and is reflected (because the debt is added at the end of the year, there will be no additional interest expense due to the new debt). Assume Uptons profit margin and dividend payout ratio will be the same in 2019 as they were in 2018. What is the amount of the line of credit reported on the 2019 forecasted balance sheets? (Hint: You dont need to forecast the income statements because the line of credit is taken out on the last day of the year and you are given the projected sales, profit margin, and dividend payout ratio; these figures allow you to calculate the 2019 addition to retained earnings for the balance sheet without actually constructing a full income statement.)
Sales transactions Using transactions listed in P4-2, indicate the effects of each transaction on the liquidity metric working capital and profitability metric gross profit percent. Indicate the gross profit percent for each sale (rounding to one decimal place) in parentheses next to the effect of the sale on the company’s ability to attain an overall gross profit percent of 30%.
Return on assets ExxonMobil Corporation (XOM) explores, produces, and distributes oil and natural gas. The Coca-Cola Company (KO) produces and distributes soft drink beverages, including Coke. Wal-Mart Stores, Inc.., (WMT) operates retail stores and supermarkets. The following data (in millions) were taken from recent financial statements of each company: Compute the return on assets for each company using the preceding data, and rank the companies’ return on assets from highest to lowest. Round the return on assets to one decimal place.
Question 1: Using Financial Ratios to Improve Working Capital Accounts. Bobs accountant found ways that ABC company could generate more cash by improving two areas, Average Collection period and ABC’s inventory turnover. With the following information, calculate how much cash ABC company could generate within the next six months if she were able to improve her average collection period to 25 days and the inventory turnover to 5 times.Revenue: 1,750,000, Cost of Sales 1,200,000, Trade Receivables 192,000, Inventories 250,000 Question 2: Calculating ROA Using the Dupont Financial System. The following Accounts are included in Marks financial statements:Cash $15,000, Revenue 2,200,000, Current assets $400,000, Prepaid expenses $43,500 Non-current assets $1,500,000, Trade receivables $157,000, Depreciation/amortization $25,000, Cost of sales $1,700,000, Distribution costs $165,000
Question 2 Ricardo Entertainment recently reported the following income statement: Sales 15,000,000 Cost of goods sold 7,500,000 EBIT 7,500,000 Interest 1,500,000 EBT 6,000,000 Taxes (40%) 2,400,000 Net income 3,600,000 The company’s CFO, Fred Mertz, wants to see a 20 percent increase in net income over the next year. Mertz has made the following observations: Ricardo’s operating margin (EBIT/Sales) was 40 percent this past year. Mertz expects that next year this margin will decrease to 35 percent. Ricardo’s interest expense is expected to remain constant. Ricardo’s tax rate is expected at 35% percent. On the basis of these numbers, what is the percentage increase in sales that Ricardo needs in order to meet Mertz’s target for net income?
Please I need step 4 Gibson Corporation’s balance sheet indicates that the company has $580,000 invested in operating assets. During the year, Gibson earned operating income of $67,280 on $1,160,000 of sales. Required Compute Gibson’s profit margin for the year. Compute Gibson’s turnover for the year. Compute Gibson’s return on investment for the year. Recompute Gibson’s ROI under each of the following independent assumptions:(1) Sales increase from $1,160,000 to $1,392,000, thereby resulting in an increase in operating income from $67,280 to $76,560.(2) Sales remain constant, but Gibson reduces expenses, resulting in an increase in operating income from $67,280 to $69,600.(3) Gibson is able to reduce its invested capital from $580,000 to $464,000 without affecting operating income.
Problem 1: A company has got $500 in cash and cash equivalents, $300 in inventory and $200 in account receivables. The firm has long term assets of $500. The firm has accounts payables of $200. All other current liabilities total $400. The firm had sales of $10000, EBIT of $5000, interest expenses of $2000 and net income of $800. Compute the following ratios: Current ratio DSO TIE profit margin Total asset turnover Problem 2: A firm has current liabilities of $500. Account receivables are $300 and inventory is $400. All other current assets equal $800. Long term assets are $5000, long term liabities are $2500, sales is $8000, EBIT is $2000, interest expenses are $600 and net income is $100. Compute the following ratios: Current ratio Debt ratio TIE ROA DSO Current ratio = total current assets/total current liabilities Days Sales Outstanding (DSO) = (accounts receivable*365)/sales Times Interest Earned (TIE) ratio = EBIT/interest expense Total asset turnover = sales/total…
2.Berman & Jaccor Corporation's current sales and partial balance sheet are shown below. This year Sales $ 1,000 Balance Sheet: Assets Cash $ 200 Short-term investments $ 135 Accounts receivable $ 100 Inventories $ 200 Total current assets $ 635 Net fixed assets $ 450 Total assets $ 1,085 Sales are expected to grow by 10% next year. Assuming no change in operations from this year to next year, what are the projected total operating assets? Do not round intermediate calculations. Round your answer to the nearest dollar. $ __.
Question 2Alex is currently considering to invest his money in one of the companies between Company A and Company B. The summarized final accounts of the companies for their last completed financial year are as follows: a. Calculate the following ratios for Company A and Company B. State clearly the formulae used for each ratio: i. Gross Profit Marginii. Net Profit Marginiii. Inventory Turnover Period (days)iv. Receivables Collection Period (days)
Economic Valuation of Business -Discounting CFAT Zara Furnishing Ltd furnishes the following Cash Flow estimate – Year 1 USD 25 Mill Year 2 to 4 compounded growth rate 7.5% Year 5 to 8 compounded growth rate 13.5% Apply 16% Discount Rate and determine the value of Business.