1. Calculate EFN (reconciled with Income Statement) 2. Prepare a projected income statement and balance sheet for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Cash Marketable securities Accounts receivable Inventory Total current Building Equipment. Total Taxes Net income Dividends Addition to retained earnings Sales Cost of goods sold Gross profit Selling and administrative expenses EBIT Interest (15,000 @ 8% + 30,000 @ 12%) EBT 1. 2. Ren Company 2022 Balance Sheet S. $5,000 5,000 10,000 35.000 55,000 100,000 15.000 4 $170.000 Accounts payable Taxes payable Accruals Total current Notes payable (8%) Bonds payable (12%) Common stock Retained earnings Total Ren Company 2022 Income Statement Schedule of Projection Assumptions for Year Ending 2023 $245,000 183.750 61,250 29.296 31,954 $ 3,000 12,000 3.500 18,500 15,000 30,000 48,000 58.500 $170,000 4.800 27,154 8,146 19,008 15.000 $ 4,008 $25,000 sales increase. Marketable securities are not spontaneous. $5,000 new equipment, net COGS is 75% of sales and Selling and administrative expenses is 12% of sales. 6. $5,000 of Bonds Payable will be retired and will NOT be rolled over.* 7. 80% of EFN financed with debt costing 11%. 8. Remaining EFN from external equity. 9. Taxes will remain at same effective tax rate as 2022. 10. Dividends payout ratio will remain the same as 2022. % 100 25 12 13 *Will have an impact on existing interest expense calculation in EFN and Projected Income Statement Cash Marketable securities Accounts receivable Inventory Total current Building Equipment. Total Taxes Net income Dividends Addition to retained earnings Sales Cost of goods sold Gross profit Selling and administrative expenses EBIT Interest (15,000 @ 8% + 30,000 @ 12%) EBT 1. 2. Ren Company 2022 Balance Sheet S. $5,000 5,000 10,000 35.000 55,000 100,000 15.000 4 $170.000 Accounts payable Taxes payable Accruals Total current Notes payable (8%) Bonds payable (12%) Common stock Retained earnings Total Ren Company 2022 Income Statement Schedule of Projection Assumptions for Year Ending 2023 $245,000 183.750 61,250 29.296 31,954 $ 3,000 12,000 3.500 18,500 15,000 30,000 48,000 58.500 $170,000 4.800 27,154 8,146 19,008 15.000 $ 4,008 $25,000 sales increase. Marketable securities are not spontaneous. $5,000 new equipment, net COGS is 75% of sales and Selling and administrative expenses is 12% of sales. 6. $5,000 of Bonds Payable will be retired and will NOT be rolled over.* 7. 80% of EFN financed with debt costing 11%. 8. Remaining EFN from external equity. 9. Taxes will remain at same effective tax rate as 2022. 10. Dividends payout ratio will remain the same as 2022. % 100 25 12 13 *Will have an impact on existing interest expense calculation in EFN and Projected Income Statement
Expert Answer:
Answer rating: 100% (QA)
Answer Lets start by calculating the External Financing Needed EFN for Ren Company for the year ending 2023 reconciled with the provided income statem... View the full answer
Related Book For
Financial Statement Analysis
ISBN: 978-0078110962
11th edition
Authors: K. R. Subramanyam, John Wild
Posted Date:
Students also viewed these finance questions
-
A drug company expects the NPV of the expenditures on its clinical drug trials will be $105 million at the start of commercialization. Commercialization is either expected to be a huge success or a...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-6. On December 12, Irene purchased the building where her store is located. She paid...
-
Pamela Albright is the manager of the audit of Stanton Enterprises, a public company that manufactures formed steel subassemblies for other manufacturers. Albright is planning the 2018 audit and is...
-
The system shown consists of 3 cables. For example; cable C12 joins points 1 and 2. The coordinates of point 1 are (6.4, 0, 0) m, those of point 2 are (0, 9.5, -6.1) m, and those of point 3 are (0,...
-
The City of Thomasville established an internal service fund to provide printing services to all city offices and departments. The following transactions related to the fund took place in 2011: 1. On...
-
A pressurized tank containing nitrogen at 800 psig is fitted with a globe valve, to which is attached a line with $10 \mathrm{ft}$ of $1 / 4$ ID stainless steel tubing and three standard elbows. The...
-
Describe hydroplaning. How can pilots calculate the minimum speed at which hydroplaning will begin?
-
Wheeled Coach, based in Winter Park, Florida, is the worlds largest manufacturer of ambulances. Working four 10-hour days each week, 350 employees make only customer-made ambulances: Virtually every...
-
The company's consolidated statement of income is provided below: (in millions of dollars) Revenues Sales by company-operated restaurant stores Revenue from franchised stores Total revenues Years...
-
Grow It All Farms Ltd. is an agri-business that grows a variety of different grains on the land that it owns. Operations have been steadily expanding over the last few years. The company has now...
-
7. Find whether the lines (t)= 0 2 0 +13,4(s)= 0 +s -1 intersect, 5. 2 parallel, coincide or skewed. If the lines intersect, find the intersection point -0
-
Can managers take actions that affect events?
-
What are two forms of the formula to find the break-even quantity?
-
Do you perform all four elements? If not, why not?
-
What is contribution margin?
-
If so, is the balance sheet you receive for your department only or for the entire organization? Do you know why this reporting method (departmental versus entire organization) was chosen by...
-
The following information was taken from a computer printout generated with the least-squares method for use in estimating overhead costs: Slope 45 Intercept 5,700 Correlation coefficient .72...
-
Should we separate the debt and equity features of convertible debt? Team 1: Pro separation: Present arguments in favor of separating the debt and equity features of convertible debt. Team 2: Against...
-
Kampa Company and Arbor Company are similar firms that operate in the same industry. Arbor began operations in 2001 and Kampa in 1995. In 2006, both companies pay 7% interest on their debt to...
-
How does the payment of dividends on preferred stock affect the EPS computation?
-
Using the income statement and balance sheets of Niagara Company below, prepare a statement of cash flows for the year ended December 31, Year 9, using the directmethod. NIAGARA COMPANY Income...
-
One of the main fears that retail startups have is if they will be able to compete against Walmart, Home Depot, and the other big-box stores. This is a legitimate fear. Big-box stores continue to...
-
Influencer marketing is a type of marketing where companies partner with influencers, who have a significant following on social media platforms, to promote their products or services. Influencers...
-
In the summer of 2015, Stephen Kuhl and Kabeer Chopra made their way to Philadelphia to prepare for business school. It was their first semester in the Wharton MBA program. They were both in an...
Study smarter with the SolutionInn App