Jay Oullette, CEO of Bumper to Bumper Inc., anticipates that his company's year-end balance sheet will show current assets of $12,774 and current liabilities of $7,590. Oullette has asked your advice concerning a possible early payment of $3,950 of accounts payable before year-end, even though payment isn't due until later. Required: Calculate the firm’s working capital and current ratio under each situation. Assume that Bumper to Bumper had negotiated a short-term bank loan of $6,000 that can be drawn down either before or after the end of the year. Calculate working capital and the current ratio at year-end under each situation, assuming that early payment of accounts payable is not made. When would you recommend that the loan be taken?

Jay Oullette, CEO of Bumper to Bumper Inc., anticipates that his company's year-end balance sheet will show current assets of $12,774 and current liabilities of $7,590. Oullette has asked your advice concerning a possible early payment of $3,950 of accounts payable before year-end, even though payment isn't due until later. Required: Calculate the firm’s working capital and current ratio under each situation. Assume that Bumper to Bumper had negotiated a short-term bank loan of $6,000 that can be drawn down either before or after the end of the year. Calculate working capital and the current ratio at year-end under each situation, assuming that early payment of accounts payable is not made. When would you recommend that the loan be taken?

Name: Jay Oullette, CEO of Bumper to Bumper Inc., anticipates that his compa
Uploaded: 2022-11-18T00:26:54.000Z
Channel: Bartleby
Description: Jay Oullette, CEO of Bumper to Bumper Inc., anticipates that his company's year-end balance sheet will show current assets of $12,774 and current liabilities of $7,590. Oullette has asked your advice concerning a possible early payment of $3,950 of a

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter4: Financial Planning And Forecasting

Section: Chapter Questions

Problem 7P

See similar textbooks

Similar questions

Starborn Company has just been established as a new company to manufacture furniture. The company expects to earn $1 million after-taxes during its first year. The company president has asked for a projected balance sheet based on ratios similar to the industry average. Assuming all sales are made on credit, calculations utilize a 365-day year, and final numbers are rounded to the nearest thousand, prepare a projected balance sheet for Starborn based on the following industry ratios: Current Ratio: 2:1 Quick Ratio: 1:1 Net Profit Margin: 10% Average Collection Period: 20 days Debt Ratio: 40% Total Asset Turnover Ratio: 2 times Current Liabilities/Stockholder's Equity: 20% Create your balance sheet based on the following format: Cash Total Current Liabilities Accounts Receivable Long-term Debt Inventory Total Debt Total Current Assets Stockholder's Equity Net Fixed Assets Total Liabilities and…
Karen Lamont is in the process of starting a new business and wants to forecast the first year's income statement and balance sheet. She has made several assumptions, which are shown below: Lamont has projected the firm's sales will be $1 million in the first year. She believes that the operating and gross profit margins will be 20 percent and 50 percent, respectively. For working capital, Lamont has estimated the following: Accounts receivable as a percentage of sales: 12% Inventory as a percentage of sales: 15% Accounts payable as a percentage of sales: 7% Accruals as a percentage of sales: 5% A bank has agreed to loan her $300,000, consisting of $100,000 in short-term debt and $200,000 in long-term debt. Both loans will have an 8 percent interest rate. The firm's tax rate will be 30 percent. Lamont will need to purchase $350,000 in plant and equipment. Lamont will provide any other financing needed.Based on Lamont's assumptions in Situation 3, prepare a pro forma income…
Karen Lamont is in the process of starting a new business and wants to forecast the first year's income statement and balance sheet. She has made several assumptions, which are shown below: Lamont has projected the firm's sales will be $1 million in the first year. She believes that the operating and gross profit margins will be 20 percent and 50 percent, respectively. For working capital, Lamont has estimated the following: Accounts receivable as a percentage of sales: 12% Inventory as a percentage of sales: 15% Accounts payable as a percentage of sales: 7% Accruals as a percentage of sales: 5% A bank has agreed to loan her $300,000, consisting of $100,000 in short-term debt and $200,000 in long-term debt. Both loans will have an 8 percent interest rate. The firm's tax rate will be 30 percent. Lamont will need to purchase $350,000 in plant and equipment. Lamont will provide any other financing needed.If her estimates in Situation 3 are correct, what will be the firm's current…
It is January 1st, 2014 and Oscar D’Souza has decided to start a new business. He wants to forecast the first year’s Income Statement and Balance sheet. He believes the assumptions below are reasonable – and wants you to assist him by creating the forecasted statements. You agree. Please construct an Income Statement and Balance Sheet from the information provided below. First year sales will total $100,000 Gross margins will be 50% Operating margins will be 20% Accounts Receivables will be about 15% of sales Inventory will be 12% of sales Accounts Payable will be 5% of sales Accrued expenses payable will be 7% of sales The Bank of Connecticut will provide a loan of $30,000. The annual interest will be 8%, compounded annually. Interest only payments are needed – until the loan is due in 5 years, where a balloon payment for the full balance must be paid. The combined federal and provincial tax rates will be 30% Capital equipment purchases will be made at the start of the year.…
Alpha Milk Corp is considering taking over their competitor, Dana Dairy Products, and asked your consultancy firm to perform financial statement analysis to assess feasibility of this strategic initiative. You are given the following key financial ratios, the firm’s income statement and the balance sheet. You can assume that there are 365 days in a year. a) Using the information provided for 31 Dec 2005, calculate the following: net working capital, current ratio, quick ratio, inventory turnover, average collection period, total debt ratio, gross profit margin, net profit margin, return on total assets, return on equity. b) Evaluate the company’s performance against industry average ratios and compare with last year’s results. To answer, please refer to pictures attached
Rick's Travel Service has asked you to help piece together financial information on the firm for the most current year. Managers give you the following information: sales are $7.4 million, total debt is $2.00 million, debt ratio is 35 percent, and ROE is 17.1 percent. Using the above information, calculate Rick's ROA. Note: Round your answer to 2 decimal places. ROA %
Manalo Inc. had the following data for 2019 (in millions). The new CFO believes that the company could improve its working capital management sufficiently to bring its NWC and CCC up to the benchmark companies' level without affecting either sales or the costs of goods sold. Manalo finances its net working capital with a bank loan at an 8% annual interest rate, and it uses a 365-day year. If these changes had been made, by how much would the firm's pre-tax income have increased?
Barry’s Superstore wishes to prepare financial plans. Use the financial statements on the next page and the other information provided below to prepare the financial plans. The following financial data are also available: (1) The firm has estimated that its sales for next year will be $130,000. (2) The firm expects to pay $30,000 in cash dividends. (3) The firm wishes to maintain a minimum cash balance of $25,000. (4) Accounts receivable represent approximately 20% of annual sales. (5) The firm’s ending inventory represents 60% of Cost of Goods Sold. (6) A new machine costing $15,000 will be purchased next year. (7) Accounts payable will increase by 5%. (8) Unearned Revenue will be earned. (9) Notes Payable would decrease by $5000. (10) Short-Term Investments and common stock will remain unchanged. Requirement: a. Prepare a pro forma income statement for the year ended December 31, 2021, using the percent-of-sales method. Tax Rate is expected to be 15%. b. Prepare a pro forma balance…
Manalo Inc. had the following data for 2019 (in millions). The new CFO believes that the company could improve its working capital management sufficiently to bring its NWC and CCC up to the benchmark companies' level without affecting either sales or the costs of goods sold. Manalo finances its net working capital with a bank loan at an 8% annual interest rate, and it uses a 365-day year. If these changes had been made, by how much would the firm's pre-tax income have increased? Original Benchmark Data Related CCC CCC Sales Cost of goods sold Inventory (iCP) Receivables (DSO) P100,000 PS0,000 P20,000 P16,000 P5,000 91.25 38.00 S8.40 20.00 20.00 28.00 Payables (POP) 22.1 12634 2,531 2,301 O 1,901 2,092 2,784
Barry’s Superstore wishes to prepare financial plans. Use the financial statements on the next page and the other information provided below to prepare the financial plans. The following financial data are also available: (1) The firm has estimated that its sales for next year will be $130,000. (2) The firm expects to pay $30,000 in cash dividends. (3) The firm wishes to maintain a minimum cash balance of $25,000. (4) Accounts receivable represent approximately 20% of annual sales. (5) The firm’s ending inventory represents 60% of Cost of Goods Sold. (6) A new machine costing $15,000 will be purchased next year. (7) Accounts payable will increase by 5%. (8) Unearned Revenue will be earned. (9) Notes Payable would decrease by $5000. (10) Short-Term Investments and common stock will remain unchanged. Requirement: Prepare a pro forma income statement for the year ended December 31, 2021, using the percent-of-sales method. Tax Rate is expected to be 15%. Prepare a pro forma balance…
Koch Engineering plc has produced the following information for its most recent financial year: (Click here to view the financial data.) Following a review of the working capital investment of the business, it was decided that liquidity could be improved if the following changes were made: 1. An decrease in the average settlement period for trade receivables to 35 days. 2. An increase in the average settlement period for trade payables to 50 days. 3. A decrease in the average inventories turnover period to 55 days. Calculate the extra cash that the business should generate by implementing each of the proposed changes. (Enter the answes in £m, round to one decimal place.) ... Trade receivables = £ m Trade payables = £m Inventories = £ m
The Balance Sheet abstract of a Company for two years are given below. You are required to – 1. Calculate, for the last year Debt-Equity Ratio, Quick Ratio, and Working Capital Turnover Ratio; and 2. Sales Volume required to maintain the same Working Capital Turnover Ratio in last year.