Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Month Revenue Jan 1 6 2 5 , 0 0 0 Feb 1 6 2 5 , 0 0 0 Mar 1 6 2 6

Month Revenue
Jan 1625,000
Feb 1625,000
Mar 1626,383
Apr 1627,348
May 1630,333
June 1629,357
July 1628,375
Aug 1630,037
Sep 1631,203
Oct 1632,383
Nov 1632,838
Dec 1632,532
Jan 1733,000
Feb 1734,003
Mar 1735,256
Apr 1735,135
May 1735,275
June 1735,984
July 1736,000
Aug 1736,894
Sep 1737,215
Oct 1737,219 You are the owner and operator of The Ninja Guy. Your first two years have been fairly successful, and you've generated a net income of $75,000 each year, and have been able to pay yourself a $60,000 salary. As you look ahead to the next year, you know that you need to prepare the budget. Forecast sales revenue for next year based on the last two years. Assuming a 95% confidence interval, what is the lower-bound sales value? The upper-bound? Attach your excel file showing that you used the forecasting function.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Foundations In Personal Finance

Authors: Dave Ramsey

College Edition

1936948001, 978-1936948000

More Books

Students also viewed these Finance questions

Question

Solve each equation. -x 2 - 8x = 16

Answered: 1 week ago