wd 19-20 - time Scenario Summary Report was created....

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

View Full Document Right Arrow Icon
Wilfredo De Leon 8a4b4707544abc64e9ae87dc7e9b64b84935480b.xls CreditUnion 10/30/2010 Klassy Kow Ice Cream, Inc. Employee Credit Union Christmas Specials Car Loan Savings Plan Number of payback years 4 Number of savings years 4 Total number of payments 48 Total number of deposits 48 Loan amount $(15,406) Deposit amount $(141) Interest rate for loan 4.50% Amount already in account $500 Interest rate 5.75% Payment at beginning of month $350.00 Amount at end of plan $7,000.00
Background image of page 1

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

View Full DocumentRight Arrow Icon
Wilfredo De Leon 8a4b4707544abc64e9ae87dc7e9b64b84935480b.xls Scenario Summary 10/30/2010 Scenario Summary Current Values: Any Hours Restricted Hours Changing Cells: $B$4 32 39 30 $B$5 20 28 34 $B$6 40 47 51 $B$7 35 41 30 $B$8 20 28 33 Result Cells: $D$9 601 750 750 Notes: Current Values column represents values of changing cells at
Background image of page 2
Background image of page 3

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

View Full DocumentRight Arrow Icon
Background image of page 4
Background image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: time Scenario Summary Report was created. Changing cells for each scenario are highlighted in gray. Wilfredo De Leon 8a4b4707544abc64e9ae87dc7e9b64b84935480b.xls DecoratingSchedule 10/30/2010 Klassy Kow Ice Cream, Inc. Employee Labor Cost Alvarez, Carl 32 4.00 128 $14.00 $448.00 Jackson, Jamal 20 5.00 100 12.50 $250.00 MacDonald, Chrystal 40 4.00 160 12.00 $480.00 Petersen, Enid 35 3.50 122.5 15.55 $544.25 Soo, Jasmine 20 4.50 90 12.65 $253.00 Total 147 21.00 601 66.70 $1,975.25 Decorating Staff Work Schedule Hand-Decorated Christmas Cakes Hours per Week Cakes per Hr Number of Cakes Hourly Wage Any Hours Page 4 38.68 28.35 46.68 40.85 27.52 Restricted Hours Page 5 30 34.29 51.43 30 32.86...
View Full Document

This note was uploaded on 10/30/2010 for the course FINANCE Excel taught by Professor Vahn during the Spring '10 term at City College of San Francisco.

Page1 / 5

wd 19-20 - time Scenario Summary Report was created....

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

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