{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

304 Sales Forecasting Assignment

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

Info icon This preview shows pages 1–9. 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
Image of page 1

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

View Full Document Right Arrow Icon
art 2 mponents 2 Equation 3 cast 3 art 1 5 art 2 5 20
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
Image of page 3

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

View Full Document Right 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 assumptions 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
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 tab (notice the difference in interest paid)
Image of page 5

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

View Full Document Right 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 D Beginning Balance Scheduled Paym Extra Paym Total Paym Principal 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 218767.13 1277.53 0 1277.53 274.84 26 41105 218492.29 1277.53 0 1277.53 276.1 27 41136 218216.18 1277.53 0 1277.53 277.37 28 41167 217938.82 1277.53 0 1277.53 278.64 29 41197 217660.18 1277.53 0 1277.53 279.92 30 41228 217380.26 1277.53 0 1277.53 281.2 31 41258 217099.06 1277.53 0 1277.53 282.49 32 41289 216816.57 1277.53 0 1277.53 283.78 33 41320 216532.79 1277.53 0 1277.53 285.08 34 41348 216247.71 1277.53 0 1277.53 286.39 35 41379 215961.32 1277.53 0 1277.53 287.7 36 41409 215673.61 1277.53 0 1277.53 289.02 37 41440 215384.59 1277.53 0 1277.53 290.35 38 41470 215094.25 1277.53 0 1277.53 291.68 39 41501 214802.57 1277.53 0 1277.53 293.01
Image of page 6
40 41532 214509.56 1277.53 0 1277.53 294.36 41 41562 214215.2 1277.53 0 1277.53 295.71 42 41593 213919.5 1277.53 0 1277.53 297.06 43 41623 213622.43 1277.53 0 1277.53 298.42 44 41654 213324.01 1277.53 0 1277.53 299.79 45 41685 213024.22 1277.53 0 1277.53 301.16 46 41713 212723.06 1277.53 0 1277.53 302.54 47 41744 212420.51 1277.53 0 1277.53 303.93 48 41774 212116.58 1277.53 0 1277.53 305.32 49 41805 211811.26 1277.53 0 1277.53 306.72 50 41835 211504.53 1277.53 0 1277.53 308.13 51 41866 211196.4 1277.53 0 1277.53 309.54 52 41897 210886.86 1277.53 0 1277.53 310.96 53 41927 210575.9 1277.53 0 1277.53 312.39 54 41958 210263.52 1277.53 0 1277.53 313.82 55 41988 209949.7 1277.53 0 1277.53 315.26 56 42019 209634.44 1277.53 0 1277.53 316.7 57 42050 209317.74 1277.53 0 1277.53 318.15 58 42078 208999.59 1277.53 0 1277.53 319.61 59 42109 208679.98 1277.53 0 1277.53 321.08 60 42139 208358.9 1277.53 0 1277.53 322.55 61 42170 208036.36 1277.53 0 1277.53 324.03 62 42200 207712.33 1277.53 0 1277.53 325.51 63 42231 207386.82 1277.53 0 1277.53 327 64 42262 207059.82 1277.53 0 1277.53 328.5 65 42292 206731.32 1277.53 0 1277.53 330.01 66 42323 206401.31 1277.53 0 1277.53 331.52 67 42353 206069.79 1277.53 0 1277.53 333.04 68 42384 205736.75 1277.53 0 1277.53 334.57 69 42415 205402.19 1277.53 0 1277.53 336.1 70 42444 205066.09 1277.53 0 1277.53 337.64 71 42475 204728.45 1277.53 0 1277.53 339.19 72 42505 204389.26 1277.53 0 1277.53 340.74 73 42536 204048.52 1277.53 0 1277.53 342.3 74 42566 203706.22 1277.53 0 1277.53 343.87 75 42597 203362.35 1277.53 0 1277.53 345.45 76 42628 203016.9 1277.53 0 1277.53 347.03 77 42658 202669.87 1277.53 0 1277.53 348.62 78 42689 202321.25 1277.53 0 1277.53 350.22 79 42719 201971.03 1277.53 0 1277.53 351.82 80 42750 201619.2 1277.53 0 1277.53 353.44 81 42781 201265.77 1277.53 0 1277.53 355.06 82 42809 200910.71 1277.53 0 1277.53 356.68 83 42840 200554.03 1277.53 0 1277.53 358.32 84 42870 200195.71 1277.53 0 1277.53 359.96 85 42901 199835.74 1277.53 0 1277.53 361.61 86 42931 199474.13 1277.53 0 1277.53 363.27 87 42962 199110.86 1277.53 0 1277.53 364.93 88 42993 198745.93 1277.53 0 1277.53 366.61 89 43023 198379.32 1277.53 0 1277.53 368.29 90 43054 198011.04 1277.53 0 1277.53 369.97 91 43084 197641.06 1277.53 0 1277.53 371.67 92 43115 197269.39 1277.53 0 1277.53 373.37 93 43146 196896.02 1277.53 0 1277.53 375.09 94 43174 196520.93 1277.53 0 1277.53 376.8 95 43205 196144.13 1277.53 0 1277.53 378.53
Image of page 7

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

View Full Document Right Arrow Icon
96 43235 195765.6 1277.53 0 1277.53 380.27 97 43266 195385.33 1277.53 0 1277.53 382.01 98 43296 195003.32 1277.53 0 1277.53 383.76 99 43327 194619.56 1277.53 0 1277.53 385.52 100 43358 194234.04 1277.53 0 1277.53 387.29 101 43388 193846.76 1277.53 0 1277.53 389.06 102 43419 193457.7 1277.53 0 1277.53 390.84 103 43449 193066.85 1277.53 0 1277.53 392.64 104 43480 192674.22 1277.53 0 1277.53 394.44 105 43511 192279.78 1277.53
Image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern