Table 3.5 presents a computer spreadsheet for estimating R&E Supplies external financing required for 2022. The text
Question:
Table 3.5 presents a computer spreadsheet for estimating R&E Supplies’ external financing required for 2022. The text mentions that with modifications to the equations for equity and net sales, the forecast can easily be extended through 2023. By referencing the appropriate cells, write the modified equations for equity and net sales for 2023.
Transcribed Image Text:
TABLE 3.5 Forecasting with a Spreadsheet: Pro Forma Financial Forecast for R&E Supplies, Inc., December 31, 2022 ($ thousands) A 2 3 4 5 6 7 Year Net sales Growth rate in net sales Cost of goods sold/net sales Gen., sell., and admin. expenses/net sales Long-term debt 20 21 22 23 24 8 9 10 11 Dividend/earnings after tax Current assets/net sales 12 13 Net fixed assets 14 15 Owners' equity Current portion long-term debt Interest rate Tax rate Current liabilities/net sales 16 INCOME STATEMENT 17 18 19 Year Net sales Cost of goods sold Gross profit Gen., sell., and admin. exp. Interest expense Earnings before tax B 2021 Actual $20,613 $ 760 $ 100 $ 1,730 Equations 2022 = B3+ B3 * C4 = C5*C19 = C19 - C20 = = C6*C19 = C9*(C7 + C8+ C40) = C21 - C22 - C23 C 2022 25.0% 86.0% 12.0% $660 $100 10.0% 25.0% 50.0% 29.0% $280 14.5% Forecast 2022 $25,766 22,159 3,607 3,092 228 287 D 2023 Forecast 2023
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 50% (2 reviews)
To forecast net sales and equity for 2023 using the provided spreadsheet we need to extend the formu...View the full answer
Answered By
Somshukla Chakraborty
I have a teaching experience of more than 4 years by now in diverse subjects like History,Geography,Political Science,Sociology,Business Enterprise,Economics,Environmental Management etc.I teach students from classes 9-12 and undergraduate students.I boards I handle are IB,IGCSE, state boards,ICSE, CBSE.I am passionate about teaching.Full satisfaction of the students is my main goal.
I have completed my graduation and master's in history from Jadavpur University Kolkata,India in 2012 and I have completed my B.Ed from the same University in 2013. I have taught in a reputed school of Kolkata (subjects-History,Geography,Civics,Political Science) from 2014-2016.I worked as a guest lecturer of history in a college of Kolkata for 2 years teaching students of 1st ,2nd and 3rd year. I taught Ancient and Modern Indian history there.I have taught in another school in Mohali,Punjab teaching students from classes 9-12.Presently I am working as an online tutor with concept tutors,Bangalore,India(Carve Niche Pvt.Ltd.) for the last 1year and also have been appointed as an online history tutor by Course Hero(California,U.S) and Vidyalai.com(Chennai,India).
4.00+
2+ Reviews
10+ Question Solved
Related Book For
ISE Analysis For Financial Management
ISBN: 9781265042639
13th International Edition
Authors: Robert C. Higgins Professor, Jennifer Koski
Question Posted:
Students also viewed these Business questions
-
A spreadsheet containing R&E Supplies 2022 pro forma financial forecast, as shown in Table 3.5, is available for download from McGraw-Hills Connect or your course instructor (see the Preface for more...
-
Table 3.5 presents a computer spreadsheet for estimating R&E Sup-plies external financing required for 2015. The text mentions that with modifications to the equations for equity and net sales, the...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
93) Clay of the Land is a manufacturer of glazed clay pots. Currently, it produces 300 clay pots per month which it sells through nurseries at a constant price of $5 per pot. Current demand for clay...
-
Public accounting serves an important role in corporate governance. Required a. Describe the role that external auditing fills in promoting good corporate governance. b. In what ways might the public...
-
Four kinds of fertilizer f1, f2, f3, and f4 are used to study the yield of beans. The soil is divided into 3 blocks each containing 4 homogeneous plots. The yields in kilograms per plot and the...
-
Assume Company A and Company B each had a balance in deferred tax assets of \(\$ 250,000\). However, Company A has a valuation allowance related to the deferred tax asset of \(\$ 200,000\) while...
-
On January 1, 2014, Primo Corporation had the following stockholders equity accounts. Common Stock ($10 par value, 75,000 shares issued and outstanding) .....$750,000 Paid-in Capital in Excess of...
-
2. In 2010, CI had purchased a subsidiary of ABC Inc. and agreed to pay additional future consideration for the pur- chase (the consideration would take the form of additional CI shares). The...
-
According to the Brookings Institution, approximately 76% of Americans drive to work alone every day. Since owning a car is a big part of our lives, it is important to understand the true cost...
-
Glacier Ski and Sports operates in the highly seasonal ski and snowboard equipment manufacturing industry. Although Glaciers sales are highly seasonal, to obtain production efficiencies it produces...
-
Continuing Problem 10, Westmark Industrials annual income statement and balance sheet for December 31, 2021, are shown next. Additional information about the companys accounting methods and the...
-
Watts Technologies Company has been purchasing carrying cases for its portable tablets at a delivered cost of $6.50 per unit. The company, which is currently operating below full capacity, charges...
-
If the number of days' sales in accounts receivable (365 days/receivables turnover) decreases significantly, which of the following assertions for accounts receivable most likely is violated? a....
-
Internal control is strengthened when the quantity of merchandise or- dered is omitted from the copy of the purchase order sent to the a. Department that initiated the requisition. b. Receiving...
-
The NCHS keeps statistics on ____ . a. The licensing information on all healthcare providers in the 50 states b. Cancer and other deadly diseases in the 50 states and the US-owned territories c....
-
Negative confirmation of accounts receivable is less effective than posi- tive confirmation of accounts receivable because a. A majority of recipients usually lack the willingness to respond...
-
In a properly designed accounts payable system, a voucher is prepared after the invoice, purchase order, requisition, and receiving report are verified. The next step in the system is a. Cancellation...
-
How has their commitment to quality and control given them a competitive edge in forming partnerships with customers and manufacturers?
-
Factor and simplify, if possible. Check your result using a graphing calculator. 3 cot 2 + 6 cot + 3
-
Consider the following alternatives: Use present worth analysis, an 8% interest rate, and an infinite analysis period. Which alternative should be selected in each of the two following situations? 1....
-
A problem often discussed in the engineering economy literature is the "oil-well pump problem"} Pump 1is a small pump; Pump 2 is a larger pump that costs more, will produce slightly more oil, and...
-
Three mutually exclusive alternatives are being studied. If the MARR is 12%, which alternative should be selected? Year A B -$20,000 -$20,000 -$20,000 +10,000 +10,000 +5,000 +10,000 2 +5,000 +5,000...
-
What piping materials might be used for a fire protection automatic sprinkler system ? Group of answer choices Black steel with welded fittings. Galvanized steel with welded fittings . EPDM . Copper....
-
A burner on an electric stove heats up unevenly turning various parts different colors. What color is the hottest part? Group of answer choices Black Yellow Bright red Orange
-
According to _____ law, a body tends to preserve its inertia. Multiple choice question. Kepler's first Newton's third Newton's first Newton's second Kepler's second
Study smarter with the SolutionInn App