Ask a Question


Sale price $30.00 Regular price $60.00


QRB 501 Week 3 Individual  Team Assignment The Business Side of Standard Deviation

You are a financial analyst for a Fortune 500 company and you must present an analysis of the financial data to the executives. 
Select a publicly traded company in the same industry as the company you work for or one that you would like to work.
Locate the company's annual report and any other available data (e.g. units manufactured, revenue, etc.) that is available for the last 5 years.
Use one of the company's historical data sets to calculate the standard deviation of the selected data for the last 5 years.
Discuss what the standard deviation means.
Analyze data using variance and standard deviation.
Create a 10-slide Microsoft® PowerPoint® presentation including detailed speaker notes in which you include the following:
Graph the company's selected financial data.
Explain the role of standard deviation in financial analysis.
Explain any other uses for standard deviation in a business setting.
Click the Assignment Files tab to submit your assignment.

QRB 501 Week 4 Individual  Assignment Math in Economics

You operate a delivery service in your local area, but you are thinking of expanding to another market.  You're concerned that you might need to set different prices in the new market because the cost of gas might be much different. 
Identify 10 gas stations in your local area.
Record the price per gallon for each gas station.
Research supply and demand curves for gasoline.
Create an Excel® spreadsheet in which you do the following:
Create a supply curve for gasoline.
Create a demand curve for gasoline.
Calculate the average cost of gas in your local area.
Calculate the standard deviation.
Determine whether the prices in your local area are higher or lower than the national average.
Create a 700-word proposal in which you include the following:
Explain elasticity of supply and demand and how this relates to your pricing decision.
Determine if your prices will be higher, lower, or the same for the new location.
Defend the pricing decision including all supporting documentation.
Cite a minimum of two scholarly references not including your text.
Click the Assignment Files tab to submit both your spreadsheet and proposal.
Request instructor assistance if you have questions concerning supply and demand curves and elasticities.

QRB 501 Week 6 Learning Team Assignment Quality Management and Quality Control
The team works for a company that is looking to make an acquisition of another company. The team must make a recommendation as to whether or not the company should make an offer based on the information below. The team must present their recommendation and all supporting information to the executive team.
Select a company with which the team is familiar. This should be a publicly traded company with sufficient financial data available online.
Identify the following information on the selected company:
Revenues = increasing by 8% each year
Expenses = increasing by 10% each year
Tax rate = 25%
Discount rate = 10%

Part I
Compute and analyze the financial data using a Microsoft® Excel® spreadsheet. Make sure all calculations can be seen in the background of the applicable spreadsheet cells. In other words, leave an audit trail so others can see how you arrived at your calculations and analysis. Items should be submitted in Microsoft® Excel®; indicate your recommendation in the Microsoft® Excel® spreadsheet: 
Calculate the 5-year projected income.
Calculate a 5-year projected cash flow.
Calculate net present value (NPV).
Calculate the internal rate of return (IRR).
Determine if the team would recommend acquiring this company based on the 4 calculations above; do you recommend acquiring this company?
Identify a quantifiable measure for the company such as service time, percent of errors, etc. Select one of the following quality control tools to evaluate this data: 
Flow chart
Cause and Effect (Fishbone) Diagram
Pareto Chart
Control Charts
Scatter Diagrams

Part II
Create a 16-slide Microsoft® PowerPoint® presentation, including detailed speaker notes or voiceover:
Define the answers you calculate in Part I.
Analyze the results you arrived at in Part I.
Interpret the answers you calculated.
Present the rationale behind each item and why it supports the team's decision.
Describe the relationship between NPV and IRR. Hint: The key factor is the discount rate used.
Format your assignment consistent with APA guidelines.
Click the Assignment Files tab to submit your assignment.
Note: Submit both the presentation and the Excel® spreadsheet with all calculations.

Questions & Answers

Have a Question?

Be the first to ask a question about this.

Ask a Question