304 Sales Forecasting Assignment

304 Sales Forecasting Assignment - Part 1 1. On the sheet...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
Part 1 1. On the sheet tab labeled Data, complete the 4 required parts of the forecasting model a. Scatter Chart Points b. Label the trend components as per the Powerpoint slideshow Scatter Cha c. Find the trend line equation Trend Com d. Forecast the sales for 2008 Trend Line 2008 Forec Loan Am pa Loan Am pa Total Part 2 1. Use the loan amortization template to complete the instructions on the Loan Am sheet tab a. use the basic loan assumptions given to complete part 1 b. make the changes as given and complete part 2
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
art 2 ponents 2 Equation 3 cast 3 art 1 5 art 2 5 20
Background image of page 2
Company LTD, Inc. Year Period Sales 1998 1 $11,500 1999 2 $12,200 2000 3 $12,500 2001 4 $11,750 2002 5 $10,750 2003 6 $10,000 2004 7 $10,750 2005 8 $10,900 2006 9 $10,000 2007 10 $9,000 2008 11 ? 1 Plot the data. What trend component(s) is present? Downward nonlinear trend possibly cyclical trend component 2 What is the trend line equation for this data? y = -300.91x + 12590 3 What is the 2008 forecasted Sales value? 9279.99 0 2 4 6 8 10 12 $0 $2,000 $4,000 $6,000 $8,000 $10,000 $12,000 $14,000 f(x) = -300.91x + 12590 Column C Linear Regres- sion for Column C Linear Regres- sion for Column C
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Loan Amortiz Find the monthly payments, total interest and total cost on a loan. Basic Loan Assumptions Item House Loan Amount $225,000 Rate 5.50% Term 30 years Set up a loan amortization schedule based on the basic loan assumption Show me what would happen if instead of financing $225,000, we put $50 Make the changes necessary, then save results to Loan Am part 2 sheet
Background image of page 4
zation Template Part 1 s in part 1, then save to the Loan Am part 1 sheet tab Part 2 0,000 down and only finance $175,000 t tab (notice the difference in interest paid)
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Loan Amortization Schedule Enter values Loan amount $225,000.00 Annual interest rate 5.50% Loan period in years 30 Number of payments per year 12 Start date of loan 40313 Optional extra payments Lender name: Pmt. No. Payment DBeginning Balance Scheduled PaymExtra PaymTotal PaymPrincipal 1 40344 225000 1277.53 0 1277.53 246.28 2 40374 224753.72 1277.53 0 1277.53 247.4 3 40405 224506.32 1277.53 0 1277.53 248.54 4 40436 224257.78 1277.53 0 1277.53 249.68 5 40466 224008.11 1277.53 0 1277.53 250.82 6 40497 223757.28 1277.53 0 1277.53 251.97 7 40527 223505.31 1277.53 0 1277.53 253.13 8 40558 223252.19 1277.53 0 1277.53 254.29 9 40589 222997.9 1277.53 0 1277.53 255.45 10 40617 222742.45 1277.53 0 1277.53 256.62 11 40648 222485.83 1277.53 0 1277.53 257.8 12 40678 222228.03 1277.53 0 1277.53 258.98 13 40709 221969.05 1277.53 0 1277.53 260.17 14 40739 221708.88 1277.53 0 1277.53 261.36 15 40770 221447.52 1277.53 0 1277.53 262.56 16 40801 221184.96 1277.53 0 1277.53 263.76 17 40831 220921.2 1277.53 0 1277.53 264.97 18 40862 220656.23 1277.53 0 1277.53 266.18 19 40892 220390.05 1277.53 0 1277.53 267.4 20 40923 220122.65 1277.53 0 1277.53 268.63 21 40954 219854.02 1277.53 0 1277.53 269.86 22 40983 219584.15 1277.53 0 1277.53 271.1 23 41014 219313.06 1277.53 0 1277.53 272.34 24 41044 219040.72 1277.53 0 1277.53 273.59 25 41075
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/12/2011 for the course FIN 304 taught by Professor Doug during the Spring '11 term at Boise State.

Page1 / 41

304 Sales Forecasting Assignment - Part 1 1. On the sheet...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online