Develop a spreadsheet model to find intercept and slope

Assignment Help Finance Basics

Reference no: EM131439420

Question: For the garage-band model you developed in Problem, define and run some reasonable scenarios using the Scenario Manager to evaluate profitability for the following scenarios:

Problem: Thomas wants to predict the sales figures of his company for the upcoming year. On the basis of historical data, he concludes that a linear function passes through the observed data points for the first and sixth years. The sales figure for the first year is $24,000, and for the sixth year is $2,000. Develop a spreadsheet model to find intercept and slope of the linear function and predict sales for the seventh year.

Reference no: EM131439420

Questions Cloud

Does junior have other legal or equitable theory of recovery : John Harrington, Jr. (“Junior”) is a 24-year-old, 3-pack-per-day smoker. John Harrington, Sr. (“Senior”) is a very concerned parent. On January 1, father announces to son, “Junior, if you will stop smoking for the entire year, I will pay you $5,000.”..

Policy described : Assume Bill owns the ISO Ho 2 policy described in this chapter. The limits are as follows: A= $120,000 B=$12,000 C=$60,000 D=$24.000 E=$100,000 F= $5,000 The replacement cost of Bill's home is $130,000, the contents are Valued at $70,000, and depreci..

Discussing some causes of aggressive behaviors : Provide some insight into Couple violence by discussing some causes of aggressive behaviors and by the role that culture plays in violence in relationships.

Provide a justified and academically defended argument : Compose a one-page essay in which you will take a first-person perspective of the situation, describe the debate in your own words, and provide a justified and academically defended argument for one side or the other. The essay will need to reflec..

Develop a spreadsheet model to find intercept and slope : Thomas wants to predict the sales figures of his company for the upcoming year. On the basis of historical data, he concludes that a linear function passes through the observed data points for the first and sixth years.

Number of customers and number of orders : Write a query to show country wise number of customers and number of orders: Run the query: SELECT count(a.customerid), count(b.orderid),a.country from Customers a inner join Orders b on a.customerid = b.customerid group by a.country

Locate and evaluate a periodical or newspaper article : Locate and evaluate a periodical or newspaper article in print or online (e.g,, Wall Street Journal, New York Times, Time magazine, The Economist, Forbes) that details an economic issue on the local, state, or federal level. Make sure that the art..

Develop an e-r diagram for lms : Develop an E-R diagram for LMS that includes at least six major entities with relationships tied between them. Consider cardinality or modality and include relationships that are potentially many-to-many, one-to-one, and one-to-many and explain wh..

Difference between data and entity models : Can you explain the difference between data and entity models, data flow diagrams and process models?

User Account

All Pages