T4_LoanAnalysis_Data

T4_LoanAnalysis_Data - $75.00 Regular Cost: $15,000.00 Over...

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

View Full Document Right Arrow Icon
Sales Dollars 83333.33 Bonus percentage 3% Bonus amount 2500
Background image of page 1

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

View Full DocumentRight Arrow Icon
Assumptions Customer Name MaryBeth Williams FICO Credit Rating 755 Purchase Price $21,000 Down Payment $3,000 Loan Term 3 (years) Application Date 1/14/2007 Outputs Payment: $557.85 per month Interest Rate: 7.25% per year Loan Term: 3 years Loan Amt. $18,000.00 Assessment $300.00 Today's Date: 6/1/11 300
Background image of page 2
pony lite Project Start Date: 01/01/08 Est. Duration (hours): 300 Completion Date: 08/01/08 Total Cost: $15,000.00 Number of Technicans: 1 Regular Hours: 300 OverTime Hours: 0 Contractor Surcharge: $200.00 Standard Per-Hour Rate: $50.00 Over Time Rate:
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
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $75.00 Regular Cost: $15,000.00 Over Time Cost: $- Total Hours Worked: 300 Scenario Summary Current Values: Scenario #3 Scenario #1 Changing Cells: $D$9 1 3 5 $D$10 300 150 10 $D$11 7 5 Result Cells: $D$7 $15,000.00 $24,475.00 $5,175.00 $D$12 $200.00 $200.00 $200.00 $D$15 $15,000.00 $22,500.00 $2,500.00 $D$16 $- $1,575.00 $1,875.00 $D$17 300 471 75 Notes: Current Values column represents values of changing cells at time Scenario Summary Report was created. Changing cells for each scenario are highlighted in gray....
View Full Document

This note was uploaded on 06/01/2011 for the course LIBERAL AR 100 taught by Professor Staff during the Spring '11 term at Oakland CC.

Page1 / 4

T4_LoanAnalysis_Data - $75.00 Regular Cost: $15,000.00 Over...

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

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