In this assignment you will create a forecast for a fictitious company using the
\nattached spreadsheet template. Input the following as assumptions in the assumption
\npart of the spreadsheet (grey highlighted cells at the top of the spreadsheet) and then
\nreference those cells when projecting the appropriate income statement, balance sheet,
\nor break-even account. Do NOT hard code numbers into your projections.
\nProject 2023 \u2013 2025 Income Statement and Balance Sheet.
\nAssumptions:
\n\u2022 Sales growth rates in each of next 3 years: 26%, 33%, 44%
\n\u2022 Operating expenses\/sales percentage stay at 2022 level
\n\u2022 Cost of goods sold as % of sales stays at 2022 level for 2023 and then
\nimproves (goes down!) by .05 in 2024 and by another .03 in 2025
\n\u2022 40% tax rate on Earnings Before Taxes
\n\u2022 No new stock issued
\n\u2022 Interest expense fixed at $400 \/ year
\n\u2022 Bank loan and LT debt stay constant
\n\u2022 2023 A\/R days = year 2022 days, then decrease by 3 days in 2024 &
\nanother 3 days in 2025
\n\u2022 2023 Inventory days = year 2022 days then decrease by 3 days in
\n2024 & another 3 days 2025
\n\u2022 A\/P days stays at year 2022 days
\n\u2022 Net fixed assets and accruals: use 2022 % of sales
\n\u2022 Required cash fixed at 1000
\n\u2022 Calculate Additional Funds Needed as plug (to get Balance Sheet to
\nbalance!)
\nCalculate 2023 breakeven revenues and units.
\nAssumptions:
\n\u2022 Use SG&A expenses as fixed costs
\n\u2022 Average price per unit is $50
\nGRADING: You will be assessed both on the accuracy of your projections as well as
\nyour proper use of spreadsheet projection etiquette (such as not hard coding numbers into cell <\/p>\n","protected":false},"excerpt":{"rendered":"
In this assignment you will create a forecast for a fictitious company using the attached spreadsheet template. Input the following as assumptions in the assumption part of the spreadsheet (grey highlighted cells at the top of the spreadsheet) and then reference those cells when projecting the appropriate income statement, balance sheet, or break-even account. […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":[],"disciplines":[18],"paper_types":[],"tagged":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/questions\/19695"}],"collection":[{"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/questions"}],"about":[{"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/types\/questions"}],"author":[{"embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/comments?post=19695"}],"version-history":[{"count":0,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/questions\/19695\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/media?parent=19695"}],"wp:term":[{"taxonomy":"disciplines","embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/disciplines?post=19695"},{"taxonomy":"paper_types","embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/paper_types?post=19695"},{"taxonomy":"tagged","embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/tagged?post=19695"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}