EBK FINANCIAL ANALYSIS WITH MICROSOFT E
8th Edition
ISBN: 9781337515528
Author: Mayes
Publisher: CENGAGE LEARNING - CONSIGNMENT
expand_more
expand_more
format_list_bulleted
Videos
Question
Chapter 4, Problem 3P
a.
Summary Introduction
To calculate: Cash budget for January 2017 to June 2017.
Introduction: Cash budgets are prepared to plan cash availability for smooth maintenance of company’s operations, they shall account for all cash in-flows and cash out-flows.
b.
Summary Introduction
To find: Minimum amount necessary for maintaining desired cash balance.
c.
Summary Introduction
To create: Best-case, base-case and worst-case scenario assuming a 10 % variation in revenue and impact of the same on loan requirement.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
The S&H construction company expects to have total sales next year totaling $14,500,00 In addition, the firm pays taxes at 35 percent and will owe $318,000 in interest expenses. Based on last year’s operations the firm’s management predicts that its cost of goods sold will be 58 percent of sales and operating expenses will total 32 percent. What is your estimate of the firm’s net income after taxes for the coming year ?
Complete the pro-forma income statement below
Round to the nearest dollar
Pro-forma income statement
Sales
Cost of goods sold
Gross profit
Operating expenses
Net operating expenses
Interested expenses
Earnings before taxes
Taxes
Net income
Cheryl Colby, CFO of Charming Florist Ltd., has created the firm’s pro forma balance sheet for the next fiscal year. Sales are projected to grow by 15 percent to $179.4 million. Current assets, fixed assets, and short-term debt are 20 percent, 90 percent, and 15 percent of sales, respectively. The company pays out 40 percent of its net income in dividends. The company currently has $27.2 million of long-term debt, and $13 million in common stock par value. The profit margin is 10 percent.
Prepare the current balance sheet for the firm using the projected sales figure.
Based on the sales growth forecast, how much does the company need in external funds for the upcoming fiscal year
Caldwell Supply, a wholesaler, has determined that its operations have three primary activities: purchasing, warehousing, and distributing. The firm reports the following operating data for the year just completed: Caldwell buys 100,900 units at an average unit cost of $19 and sells them at an average unit price of $29. The firm also has fixed operating costs of $250,900 for the year. Caldwell's customers are demanding a 19% discount for the coming year. The company expects to sell the same amount if the demand for price reduction can be met. Caldwell's suppliers, however, are willing to give only a 14% discount. Required: Caldwell has estimated that it can reduce the number of purchase orders to 770 and can decrease the cost of shipment by $12 with minor changes in its operations. Any further cost savings must come from reengineering the warehousing processes. What is the maximum cost (i.e., target cost) for warehousing if the firm desires to earn the same amount of profit next year?
Chapter 4 Solutions
EBK FINANCIAL ANALYSIS WITH MICROSOFT E
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Similar questions
- The Frozen North Construction Company would like to forecast its minimum volume of work (turnover) in order to “break even” (i.e., cover its corporate overheads) for the coming year. The company’s previous year’s corporate overheads were $900,000. The company anticipates 22% inflation and 6% growth in the firm for the coming year. It also expects to achieve a gross margin of 13% on its projects, based on old experience. The company defines gross margin as a percentage of revenue (i.e., selling price). Determine the minimum volume of work, which will allow the Frozen North Company to break even at the end of the coming year.arrow_forwardDahlia Colby, CFO of Charming Florist Ltd., has created the firm’s pro forma balance sheet for the next fiscal year. Sales are projected to grow by 10 percent to $330 million. Current assets, fixed assets, and short-term debt are 25 percent, 70 percent, and 15 percent of sales, respectively. Charming Florist pays out 25 percent of its net income in dividends. The company currently has $121 million of long-term debt and $49 million in common stock par value. The profit margin is 9 percent. 1. Based on Ms. Colby’s sales growth forecast, how much does Charming Florist need in external funds for the upcoming fiscal year? 2. Construct the firm’s pro forma balance sheet for the next fiscal year 3. Calculate the external funds neededarrow_forwardCaldwell Supply, a wholesaler, has determined that its operations have three primary activities: purchasing, warehousing, and distributing. The firm reports the following operating data for the year just completed: Caldwell buys 100, 100 units at an average unit cost of $11 and sells them at an average unit price of $21. The firm also has fixed operating costs of $250,100 for the year. Caldwell's customers are demanding a 11% discount for the coming year. The company expects to sell the same amount if the demand for price reduction can be met. Caldwell's suppliers, however, are willing to give only a 3% discount. Required: Caldwell has estimated that it can reduce the number of purchase orders to 690 and can decrease the cost of each shipment by $4 with minor changes in its operations. Any further cost savings must come from reengineering the warehousing processes. What is the maximum cost (i.e., target cost) for warehousing if the firm desires to earn the same amount of profit next…arrow_forward
- The following data refer to Clear Panes, a division of Global Corporation. Clear Panes makes and sells residential windows that sell for $150 each. Clear Panes expects sales of 150,000 units in 2017. Clear Panes’ annual fixed costs are $2,750,000 and their variable cost is $90 per window. Global evaluates Clear Panes based on residual income. The total investment attributed to Clear Panes is $12 million and the required rate of return on investment is 16%. Ignore taxes and depreciation expense. Answer each of the following parts independently, unless otherwise stated. Q. What is the expected residual income in 2017?arrow_forwardThe following data refer to Clear Panes, a division of Global Corporation. Clear Panes makes and sells residential windows that sell for $150 each. Clear Panes expects sales of 150,000 units in 2017. Clear Panes’ annual fixed costs are $2,750,000 and their variable cost is $90 per window. Global evaluates Clear Panes based on residual income. The total investment attributed to Clear Panes is $12 million and the required rate of return on investment is 16%. Ignore taxes and depreciation expense. Answer each of the following parts independently, unless otherwise stated. Q. The window latch Clear Panes manufactures for its windows has a variable cost of $20. An outside vendor has offered to supply the 150,000 units required at a cost of $21 per unit. If the component is purchased outside, fixed costs will decline by $100,000 and assets with a book value of $150,000 will be sold at book value. Will Clear Panes decide to make or buy the component? Explain your answer.arrow_forwardThe following data refer to Clear Panes, a division of Global Corporation. Clear Panes makes and sells residential windows that sell for $150 each. Clear Panes expects sales of 150,000 units in 2017. Clear Panes’ annual fixed costs are $2,750,000 and their variable cost is $90 per window. Global evaluates Clear Panes based on residual income. The total investment attributed to Clear Panes is $12 million and the required rate of return on investment is 16%. Ignore taxes and depreciation expense. Answer each of the following parts independently, unless otherwise stated. Q. Clear Panes receives an external special order for 10,000 units at $120 each. If the order is accepted, Clear Panes will have to incur incremental fixed costs of $250,000 and invest an additional $450,000 in various assets. What is the effect on Clear Panes’s residual income of accepting the order?arrow_forward
- Milano Pizza Club owns three identical restaurants popular for their specialty pizzas. Each restaurant has a debt-to-equity ratio of 40 percent and makes Interest payments of $43,000 at the end of each year. The cost of the firm's levered equity is 16 percent. Each store estimates that annual sales will be $1.29 million, annual cost of goods sold will be $550,500, and annual general and administrative costs will be $367,000. These cash flows are expected to remain the same forever. The corporate tax rate is 40 percent. a. Use the FTE approach to determine the value of the company's equity. (Round the answer to 2 decimal places. Omit $ sign in your response.) Equity value $ 4,513,125.00 ✪ b. What is the total value of the company? (Do not round Intermediate calculations. Round the final answer to 2 decimal places. Omit $ sign in your response.) 6,318,375.00 Total valuearrow_forwardPharoah Construction Company enters into a contract with a customer to build a warehouse for $211,000, with a performancebonus of $105,500 that will be paid based on the timing of completion. The amount of the performance bonus decreases by 10% perweek for every week beyond the agreed-on completion date. The contract requirements are similar to contracts that Pharoah hasperformed previously, and management believes that such experience is predictive for this contract. Management estimates thatthere is a 60% probability that the contract will be completed by the agreed-on completion date, a 30% probability that it will becompleted one week late, and a 10% probability that it will be completed two weeks late. whats the tranction price.arrow_forwardIt is December 31. Last year, Campbell Construction had sales of $80,000,000, and it forecasts that next year’s sales will be $76,000,000. Its fixed costs have been—and are expected to continue to be—$40,000,000, and its variable cost ratio is 21.00%. Campbell’s capital structure consists of a $15 million bank loan, on which it pays an interest rate of 8%, and 750,000 shares of common equity. The company’s profits are taxed at a marginal rate of 40%. The following are the two principal equations that can be used to calculate a firm’s DFL value: DFL (at EBIT = $X)=Percentage Change in EPSPercentage Change in EBITDFL (at EBIT = $X)=Percentage Change in EPSPercentage Change in EBIT DFL (at EBIT = $X)=EBITEBIT−Interest−Preferred Dividends(1 – Tax Rate)DFL (at EBIT = $X)=EBITEBIT−Interest−Preferred Dividends(1 – Tax Rate) Given this infromation, complete the following sentences: • The company’s percentage change in EBIT is ______(-12.26%/ -16.34%/ -13.62%) . • The percentage change…arrow_forward
- Camp Manufacturing turns over its inventory eight times each year, has an average payment period of 35 days, and has an average collection period of 60 days. The firm’s annual sales are $3.5 million. Assume there is no difference in the investment per dollar of sales in inventory, receivables, and payables and that there is a 365-day year. If the firm pays 14% for these resources, by how much would it increase its annual profits by favorably changing its current cash conversion cycle by 20 days?arrow_forwardOn January 1, Revis Consulting entered into a contract to complete a cost reduction program for Green Financial over a six-month period. Revis will receive $68,000 from Green at the end of each month. If total cost savings reach a specific target, Revis will receive an additional $34,000 from Green at the end of the contract, but if total cost savings fall short, Revis will refund $34,000 to Green. Revis estimates an 80% chance that cost savings will reach the target and calculates the contract price based on the expected value of future payments to be received. Required: Prepare the following journal entries for Revis: 1. Prepare the journal entry on January 31 to record the collection of cash and recognition of the first month's revenue. 2. Assuming total cost savings exceed target, prepare the journal entry on June 30 to record receipt of the bonus. 3. Assuming total cost savings fall short of target, prepare the journal entry on June 30 to record payment of the penalty. Note: If no…arrow_forwardThe Milton Company currently purchases an average of $25,000 per day in raw materials on credit terms of "net 35." The company expects sales to increase substantially next year and anticipates that its raw material purchases will increase to an average of $29,000 per day. Milton feels that it may need to finance part of this sales expansion by stretching accounts payable. Round your answers to the nearest dollar. Assuming that Milton currently waits until the end of the credit period to pay its raw material suppliers, what is its current level of trade credit? $ If Milton stretches its accounts payable an extra 5 days beyond the due date next year, how much additional short-term funds (that is, trade credit) will be generated? $arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Intermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
How To Analyze an Income Statement; Author: Daniel Pronk;https://www.youtube.com/watch?v=uVHGgSXtQmE;License: Standard Youtube License