2 a b d Based upon the figures below and the financial forecast for the years...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
2 a b d Based upon the figures below and the financial forecast for the years 2023 2027, compute 1a through 1d below, placing your final results in the yellow highlighted area. HINT: All formulas needed to solve 1a-1d come from your Week 4 Lesson and Week 4 Chapter readings. GIVEN: Quantity of windows sold (Q) Selling price per window (P) Variable Costs per window (VC) Total Fixed Costs (FC) Total Variable Costs (TVC) SOLVE FOR: Contribution Margin Ratio Breakeven in sales dollars. DOL DFL 3 pts 3 pts 4 pts 4 pts 2023 4,000 $1,000 $500 $500,000 $2,000,000 2023 2024 5,000 $1,000 $600 2025 2024 6,000 $1,000 $583 2026 2025 7,000 $1,000 $571 $500,000 $500,000 $500,000 $500,000 $3,000,000 $3,500,000 $4,000,000 $5,000,000 2026 2027 (14 pts) Based upon your financial forecast for the years 2023 - 2027, compute 2a through 2d below FROM THE VIEWPOINT OF THE SHARK, placing your final results in the yellow highlighted area. 8,000 $1,000 $625 2027 a b d GIVEN: NOTE 1: The shark's investment of $1,000,000 gave him 25% ownership of your company and its profits. NOTE 2: The shark requires a 9% Rate of Return on his investment. NOTE 3: Cash Flows from Operations (Total for company) SOLVE FOR: Cash Flows from Operations (shark only) Payback (in years) of the shark's $1M investment (x.xx years) IRR of shark's investment NPV of shark's investment 3 pts 3 pts 4 pts 4 pts ($1,000,000) 2023 $372,212 2023 2024 2025 $843,095 $1,066,542 2024 2025 2026 2027 $1,330,902 $1,554,349 2026 2027 3 4 (3 pts) What is the growth rate of Net Income for each of the forecasted years? (4 pts) Compute the following for the forecasted years. (Total company) 2023 2024 2025 2026 2027 GIVEN: NOTE 1: Dividends are zero every year. NOTE 2: $750,000 of the $1M invested by the shark was spent on Capital Expenditures in 2023. No other capital expeditures occurred. a b GIVEN: NOTE 1: Dividends are zero every year. NOTE 2: $750,000 of the $1M invested by the shark was spent on Capital Expenditures in 2023. No other capital expeditures occurred. SOLVE FOR: Free Cash Flow Free Cash Flow per share 3 pts 1 pt 2023 2024 2025 2026 2027 2 a b d Based upon the figures below and the financial forecast for the years 2023 2027, compute 1a through 1d below, placing your final results in the yellow highlighted area. HINT: All formulas needed to solve 1a-1d come from your Week 4 Lesson and Week 4 Chapter readings. GIVEN: Quantity of windows sold (Q) Selling price per window (P) Variable Costs per window (VC) Total Fixed Costs (FC) Total Variable Costs (TVC) SOLVE FOR: Contribution Margin Ratio Breakeven in sales dollars. DOL DFL 3 pts 3 pts 4 pts 4 pts 2023 4,000 $1,000 $500 $500,000 $2,000,000 2023 2024 5,000 $1,000 $600 2025 2024 6,000 $1,000 $583 2026 2025 7,000 $1,000 $571 $500,000 $500,000 $500,000 $500,000 $3,000,000 $3,500,000 $4,000,000 $5,000,000 2026 2027 (14 pts) Based upon your financial forecast for the years 2023 - 2027, compute 2a through 2d below FROM THE VIEWPOINT OF THE SHARK, placing your final results in the yellow highlighted area. 8,000 $1,000 $625 2027 a b d GIVEN: NOTE 1: The shark's investment of $1,000,000 gave him 25% ownership of your company and its profits. NOTE 2: The shark requires a 9% Rate of Return on his investment. NOTE 3: Cash Flows from Operations (Total for company) SOLVE FOR: Cash Flows from Operations (shark only) Payback (in years) of the shark's $1M investment (x.xx years) IRR of shark's investment NPV of shark's investment 3 pts 3 pts 4 pts 4 pts ($1,000,000) 2023 $372,212 2023 2024 2025 $843,095 $1,066,542 2024 2025 2026 2027 $1,330,902 $1,554,349 2026 2027 3 4 (3 pts) What is the growth rate of Net Income for each of the forecasted years? (4 pts) Compute the following for the forecasted years. (Total company) 2023 2024 2025 2026 2027 GIVEN: NOTE 1: Dividends are zero every year. NOTE 2: $750,000 of the $1M invested by the shark was spent on Capital Expenditures in 2023. No other capital expeditures occurred. a b GIVEN: NOTE 1: Dividends are zero every year. NOTE 2: $750,000 of the $1M invested by the shark was spent on Capital Expenditures in 2023. No other capital expeditures occurred. SOLVE FOR: Free Cash Flow Free Cash Flow per share 3 pts 1 pt 2023 2024 2025 2026 2027
Expert Answer:
Answer rating: 100% (QA)
To begin solving these questions we need to work through each one step by step based on the information provided Lets start with computing the Contribution Margin Ratio Breakeven in sales dollars Degr... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these finance questions
-
ABC Clothing had opened on January 1, 2022. The following activities have occurred since the opening day: on January 1st, the company received $40,000 of equity from investors on January 1st, the...
-
Given the below code segment: char str[10] = {'G','o','o','d', D','o', 'lo', 'y', '\0'; int b = strlen (str); What is the value of b?
-
Trent Marcus has 3 major suppliers: Parker is in the same business as Trent and offers a 5 % trade disc Scott offers a trade disc of 6 % on amounts in excess of $ 200 ( trade disc does not apply to...
-
In a typing class, the average number N of words per minute typed after t weeks of lessons is N = 157 / (1 + 5.4e0.12t). Find the time necessary to type (a) 50 words per minute and (b) 75 words per...
-
Which of the following adjustments helps to convert accrual income to operating cash flows? a. Add to net income an increase in inventories b. Deduct from net income a decrease in inventories c. Add...
-
An increasing number of states are opting to legalize marijuana for medicinal use, and some states have legalized this substance for recreational use as well. Paul Platt has a serious medical...
-
Your new audit client, Hardwood Lumber Company, has a computerized accounting system for all financial statement cycles. During planning, you visited with the information systems vice president and...
-
19 20 Assertion A compass needle is placed near a current carrying wire. The deflection of the compass needle decreases when the magnitude of the current in the wire is increased. Reason The strength...
-
The Alfredo Fragrance Company produces only one product, a perfume called Hint of Elegance. Hint of Elegance consists of two secret ingredients blended into an exclusive fragrance, which is marketed...
-
A (3 m x 8 m) footing is designed for a multistory building; the footing is constructed at a depth of 3m below the ground surface; the foundation is subjected to a stress of 110 kN/m Bedrock layer is...
-
The wind chill temperature, in Fahrenheit, on a cold winter day in Montana is -47 F. What is this temperature in Kelvin?
-
Magenta light shines on a green shirt. What color of light would you expect to be reflected?
-
Value chain analysis divides activities of the firm into two categories; Primary activity and Secondary Activity. If you are analyzing activities of a car company, what activity you would consider as...
-
The Guitar Emporium just opened their new website to sell guitars. Below are some of the statistics from their first 3 months of eCommerce. Site visitors Jan = 600 Number of sales Jan = 10 Revenue...
-
The automotive parts market has seen significant growth as economic conditions around the world are slowing sales of new vehicles. Another aspect that has made it difficult to market new units is the...
-
On January 1, Year 2 Grande Company had a $26,000 balance in the Accounts Receivable account and a zero balance in the Allowance for Doubtful Accounts account. During Year 2, Grande provided $88,000...
-
In the busy port of Chennai, India, the number of containers loaded onto ships during a 15-week period is as follows: 1. Develop a linear trend equation to forecast container loadings. 2. Using the...
-
For each of the following cases, indicate the filing status for the taxpayer(s) for 2012 using the following legend: A - Single B - Married, filing a joint return C - Married, filing separate returns...
-
Cedar Corporation has an S corporation election in effect. During the 2012 calendar tax year, the corporation had ordinary taxable income of $200,000, and on January 15, 2012, the corporation paid...
-
Olive Corporation was formed and began operations on January 1, 2012. The corporation's income statement for the year and the balance sheet at year-end are presented below. The corporation made...
-
Which of the following best describes the underlying rationale for a written investment policy statement (IPS)? A. A written IPS communicates a plan for trying to achieve investment success. B. A...
-
Which of the following is least important as a reason for a written investment policy statement (IPS)? A. The IPS may be required by regulation. B. Having a written IPS is part of best practice for a...
-
A written investment policy statement (IPS) is most likely to succeed if: A. Created by a software program to assure consistent quality. B. It is a collaborative effort of the client and the...
Study smarter with the SolutionInn App