Question: please help me doing this by Microsoft Excel? thankyou Case 5. Financial forecasting (20%) Table below shows the sales and cost of good sold per

please help me doing this by Microsoft Excel? thankyou

Case 5. Financial forecasting (20%) Table below shows the sales and cost of good sold per year for Healthiness Co. Year Sales Cost of Goods Sold 2020 2,490,532 1,570,200 2021 2,387,987 1,495,694 2022 3,590,210 2,389,534 2023 4,836,910 3,760,920 2024 5,290,540 4,245,908 Instructions: a. Predict the Sales Growth in 2025-2027 using TREND function! b. Make the Graph for Sales & Cost of Goods Sold Growth and The Prediction of Sales Growth! c. Do the regression from data above, and how about the intercept and sales nominal? (show the regression results). d. Calculate the prediction of Cost of Goods Sold for 2026! (using intercept and sales from regression results)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Assume that the axial load P applied to the lap joint is distributed equally among the three 20-mm-diameter rivets. What is the maximum load P that can be applied if the allowable stresses are 40 MPa...

CASE "Aspiring entrepreneurs Bill and Fiona Russell have always had a passion for homebrewing on a small scale. After recent work changes, Bill started researching opening a small brewery, and...

Required case analysis: As an Operations Management Consultant, XYZ has hired you to help determine how it can improve its operations management by using the available resources. You are required to...

Please help, we must submit the attached Excel document with a short report. Below are FAQs. Thanks in advance. For the Fosbuvir Project, I see numbers for the revenue for year 1 as $10 billion and...

Please help with the attached assignment. I have already completed the financial forecast in excel (attached), I ONLY just need help with the written portion of the assignment (instructions attached)...

B. What, if any, issues/challenges do you see with the customer profitability measurements from the initial customer profitability system, provided in Exhibit 2? What assumption(s) is the customer...

D. Now consider the alternate customer profitability system that Jamestown is contemplating. How does the alternate system differ (e.g., underlying assumptions, categorization and treatment of...

Can you please help me with questions 8 and 9 for Case 6..... I have answers to questions 1-7 if needed... Cases for Management Decision-Making CA-1 Suggested Uses of Cases Case Overview CASE 1 This...

PLENITUDE INC. Plenitude Inc. (Plenitude) is a national food-processing company that specializes in the creation of healthy and easy-to-prepare frozen meal kits that are sold in major grocery stores...

after 3 tables of data, please analyze common size calculations and analysis for 2021. please show me work in excel will rate!! B Global Manufacturing, Inc. Introduction Phil Jackson, President and...

Calculate and show all calculation steps for weights, cost of debts, costs of equities, and weighted average costs of capital with proper written explanations. In particular, (most importantly) show...

In 2014, Charlie Snyder opened Charlies Pets, a small retail shop selling pet supplies. On December 31, 2014, the accounting records of Charlies Pets showed the following: Inventory on December 31,...

Define technical words and explain how you would make decisions about their use in your business messages.

What is a benefit of the functional / structural model but not the matrix model?

A 10 kg brick moves along an x axis. Its acceleration as a function of its position is shown in Fig. 7-40.The scale of the figure's vertical axis is set by as = 20.0 m/s2. What is the net work...

To pull a 50 kg crate across a horizontal frictionless floor, a worker applies a force of 210 N, directed 20o above the horizontal. As the crate moves 3.0 m, what work is done on the crate by (a) The...

In Figure, we must apply a force of magnitude 80 N to hold the block stationary at x = 2.0 cm. From that position, we then slowly move the block so that our force does + 4.0 J of work on the...

Canney Company borrows $90,000 on July 1 from the bank by signing a $90,000, 7%, 1-year note payable. Prepare the journal entries to record (a) The proceeds of the note and (b) Accrued interest at...

Alternative allocation bases for a professional services firm. The Wolfson Group (WO) provides tax advice to multinational firms. WG charges clients for (a) direct professional time (at an hourly...

Tom is a shareholder of Unit Company. As a shareholder, Tom does not have a right to O profit from the sale of his shares. O manage the company on a day-to-day basis. corporate assets on Unit's...

4. Achieve our positive goals (1 and 3 are motivated by avoiding the negative, while 2 and 4 are motivated by the positive). b. Initiative: When I communicate with others, I think it is very...

18. In the statements below, put a cross for the statement you feel characterizes yourself best when you communicate with others. Its not necessarily the way you know you should communicate, but the...

10. What activities in your life best express the value you want others to associate with you?