The management team at Taylor, Inc. is working on the company's 2019 pro-forma balance sheet and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The management team at Taylor, Inc. is working on the company's 2019 pro-forma balance sheet and income statement, and wishes to find out the amount of additional external funds it will need in 2019, based on the following assumptions: a. Sales are expected to double in 2019. b. The company is operating at full capacity. c. All operating assets (cash included) and spontaneous liabilities are expected to remain at their same proportion of sales as in 2018. Misc. assets (which are non- operating assets) will remain unchanged at $7,500. d. Cost of Goods Sold and Operating Expenses are also expected to remain equal in proportion of sales. e. Management expects Interest rates to fall in 2019 so that interest expenses will remain constant as a percentage of sales, even if the level of bank debt increases in 2019. In addition, assume that interest rates are the same for short-term and long-term debt. f. The company's tax rate is 40% and the firm does not pay dividends. 1) What are the Additional Funds Needed (AFN) for the year 2019, using both the AFN formula and a pro-forma balance sheet using the pct. of sales method? Both methods should give you the same result. 2) Now assume that, in 2019, while doubling its level of sales, the company wishes to improve its Days Payable to a more acceptable level of 60 days. What will then be the level of AFN? 3) In addition to reducing its Days Payable, the firm also wants to bring its Debt/Equity ratio as close as possible to, but not to exceed 2/1, and its current ratio as close as possible to, but not to fall below 2/1. How would this newly calculated level of AFN (from Question 2) be allocated among additional sources of funds, i.e., notes payable (N/P), long-term debt, and/or newly issued common stock? Assume that additional long-term debt and common stock can only be obtained in multiples of $50,000 (i.e., $50,000, $100,000, $250,000, etc., and not $75,000 or $125,000, etc.) Additional Notes Payable can be obtained in any amount. 4) Prepare your pro-forma Income Statement and Balance Sheet accordingly. For your ratios, assume a 365 day and use the following formulas: End of Year A/P Days Payable= COGS 365 End of Year Debt Equity End of Year Equity Note: The term "Debt" includes all forms of liabilities, not just bank debt. Please find below Taylor, Inc.'s financial statements for the past two years: Taylor, Inc. Debt B Cash Accounts Receivable Inventory Total Current assets Net Fixed assets Misc. Long-Term Assets Total Assets Notes Payable Accounts Payable Total Current Liabilities Long-Term Debt Total Liabilities Net Worth (Com. Eq. + R.E.) Total Liabilities & Net Worth Net Sales COGS Gross Profit Operating Expenses EBIT Interest Expense EBT Taxes Net Income 2017 15,000 180,000 360,000 2018 15,000 360,000 720,000 555,000 1,095,000 217,500 367,500 7,500 7,500 780,000 1,470,000 135,000 135,000 225,000 682,500 360,000 817,500 150,000 262,500 510,000 1,080,000 270,000 390,000 780,000 1,470,000 40,000 60,000 2,160,000 4,320,000 1,440,000 2,880,000 720,000 1,440,000 601,250 1,212,250 118,750 227,750 18,750 27,750 100,000 200,000 80,000 120,000 The management team at Taylor, Inc. is working on the company's 2019 pro-forma balance sheet and income statement, and wishes to find out the amount of additional external funds it will need in 2019, based on the following assumptions: a. Sales are expected to double in 2019. b. The company is operating at full capacity. c. All operating assets (cash included) and spontaneous liabilities are expected to remain at their same proportion of sales as in 2018. Misc. assets (which are non- operating assets) will remain unchanged at $7,500. d. Cost of Goods Sold and Operating Expenses are also expected to remain equal in proportion of sales. e. Management expects Interest rates to fall in 2019 so that interest expenses will remain constant as a percentage of sales, even if the level of bank debt increases in 2019. In addition, assume that interest rates are the same for short-term and long-term debt. f. The company's tax rate is 40% and the firm does not pay dividends. 1) What are the Additional Funds Needed (AFN) for the year 2019, using both the AFN formula and a pro-forma balance sheet using the pct. of sales method? Both methods should give you the same result. 2) Now assume that, in 2019, while doubling its level of sales, the company wishes to improve its Days Payable to a more acceptable level of 60 days. What will then be the level of AFN? 3) In addition to reducing its Days Payable, the firm also wants to bring its Debt/Equity ratio as close as possible to, but not to exceed 2/1, and its current ratio as close as possible to, but not to fall below 2/1. How would this newly calculated level of AFN (from Question 2) be allocated among additional sources of funds, i.e., notes payable (N/P), long-term debt, and/or newly issued common stock? Assume that additional long-term debt and common stock can only be obtained in multiples of $50,000 (i.e., $50,000, $100,000, $250,000, etc., and not $75,000 or $125,000, etc.) Additional Notes Payable can be obtained in any amount. 4) Prepare your pro-forma Income Statement and Balance Sheet accordingly. For your ratios, assume a 365 day and use the following formulas: End of Year A/P Days Payable= COGS 365 End of Year Debt Equity End of Year Equity Note: The term "Debt" includes all forms of liabilities, not just bank debt. Please find below Taylor, Inc.'s financial statements for the past two years: Taylor, Inc. Debt B Cash Accounts Receivable Inventory Total Current assets Net Fixed assets Misc. Long-Term Assets Total Assets Notes Payable Accounts Payable Total Current Liabilities Long-Term Debt Total Liabilities Net Worth (Com. Eq. + R.E.) Total Liabilities & Net Worth Net Sales COGS Gross Profit Operating Expenses EBIT Interest Expense EBT Taxes Net Income 2017 15,000 180,000 360,000 2018 15,000 360,000 720,000 555,000 1,095,000 217,500 367,500 7,500 7,500 780,000 1,470,000 135,000 135,000 225,000 682,500 360,000 817,500 150,000 262,500 510,000 1,080,000 270,000 390,000 780,000 1,470,000 40,000 60,000 2,160,000 4,320,000 1,440,000 2,880,000 720,000 1,440,000 601,250 1,212,250 118,750 227,750 18,750 27,750 100,000 200,000 80,000 120,000
Expert Answer:
Answer rating: 100% (QA)
The differential equation x12yx23x2y3y0 is solved near a regular sing... View the full answer
Related Book For
Intermediate Accounting
ISBN: 978-0324312140
16th Edition
Authors: James D. Stice, Earl K. Stice, Fred Skousen
Posted Date:
Students also viewed these finance questions
-
The 2018 comparative balance sheet and income statement of Attleboro Group, Inc. follow. Attleboro disposed of a plant asset at book value in 2018. Prepare the spreadsheet for the 2018 statement of...
-
The 2016 comparative balance sheet and income statement of Abilene Group, Inc. follow. Abilene disposed of a plant asset at book value in 2016. Prepare the spreadsheet for the 2016 statement of cash...
-
The 2018 comparative balance sheet and income statement of Appleton Group, Inc. follow. Appleton disposed of a plant asset at book value during 2018. Prepare the spreadsheet for the 2018 statement of...
-
The post-closing trial balances of two proprietorships on January 1, 2010, are presented below. Patrick and Samuelson decide to form a partnership, Pasa Company, with the following agreed upon...
-
Examine what happens to the current ratio when: a. An accounts payable is paid with cash. b. Inventory is purchased on credit. c. Money is received from a debtor.
-
looking at a Coffee Product 1. what type of layout do you consider most appropriate? 2. what elements do you consider important to the design of the job and work required to manufacture your product...
-
Calculations Adams Corporation initially records its sales at amounts that exclude any related excise and sales taxes. During May, Adams recorded total sales of \(\$ 750,000\). An analysis of May...
-
Consider the revised Coal Bank Hollow recycling problem discussed in section 5.5.4 of this chapter. We said that it is safest to assume the supply in a generalized network flow problem is capable of...
-
3 eBook A company budgets production of 4,800 units for June. Each unit uses 2 hours of direct labor at $38 per hour. Prepare a direct labor budget for June. Direct Labor Budget June Print References...
-
Multiple regression is used by accountants in cost analysis to shed light on the factors that cause costs to be incurred and the magnitudes of their effects. Sometimes, it is desirable to use...
-
A spaceship traveling at 0.9c (90% the speed of light) is equipped with a 10-meter long rod that extends in the direction of motion. According to an observer on the spaceship, how long is the rod?...
-
Let Then A = (3 11 9), B =0 921 = 0 922 = 0 where a11= 63 a12= -1 7 0 B= 9 8 3 AB-() = b11 b12 b13 BA= b21 b22 b23 b31 b32 b33/ == where 611 =612=-613 = 621 = b22 = b23 = 631 = 632 = 633 = and C11...
-
Solve the equation for x. (6x+13)4 = (x+3)4 x= (Simplify your answer. Use a comma to separate answers as needed.)
-
In January, the United Kingdom saw a record net budget surplus of 16.7 billion ($21.1 billion), attributed to the typical surplus pattern in January due to receipts from self-assessed annual income...
-
Despite being particularly annoyed by a difficult coworker in the past, Rachel Chen recently described the coworker to a colleague in relatively positive terms. Based on your understanding of the...
-
Discuss the first, second, third, fourth, and fifth concepts, strategies, or lessons learned that you found most valuable in the course. Remember, explain in detail why you found it significant and...
-
Debtor's account number e.g. Min 120 Name e.g. Minolta Printing Ltd Address and contact details 25 Mimosa Drive, Germiston, 4144 Contact Details 011 567 8890 Date account opened February 2014 Total...
-
Explain what is meant by vicarious liability and when it is available?
-
Assume that $200,000 of Baker School District 6% bonds are sold on the bond issue date for $185,788. Interest is payable semiannually, and the bonds mature in 10 years. The purchase price provides a...
-
Account balances taken from the ledger of Royal Distributing Co. on December 31, 2008, follow: Cash . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $...
-
A newly hired staff accountant prepared the pre-audit income statement of Jericho Recreation Incorporated for the year ending December 31, 2008. The following information was obtained by Jericho's...
-
Use the working papers from On Your Own 18-2. A comparative balance sheet and forms for analyzing changes in long-term assets, long-term liabilities, and stockholders' equity are provided in the...
-
Use the statement of cash flows started in Application Problem 18-2. The comparative balance sheet of Flexcor Corporation lists the following long-term assets and their ending balances for the...
-
Use the statement of cash flows started in Application Problem 18-2. The comparative balance sheet of Flexcor Corporation lists the following long-term liability and its ending balance for the...
Study smarter with the SolutionInn App