Documentation
Shelly Cashman Excel 2016 | Module 4: SAM Project 1a
Camp Millowski
FINANCIAL FUNCTIONS, DATA TABLES, AND AMORTIZATION SCHEDULES
Author: Jesus Mojica
Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website.
Campground Mortgage
Camp Millowski
Mortgage Loan Payment Calculator Amortization Schedule
Date 15-Aug-18 Rate 5.750% Year Beginning Balance Ending Balance Paid on Principal Interest Paid
Item Campground Term (Years) 15 1 $ 388,800.00 $ 371,973.53
Price $ 486,000.00 Monthly Payment 2 $ 371,973.53 $ 354,153.63
Down Payment $ 97,200.00 Total Interest $ (388,800.00) 3 $ 354,153.63 $ 335,281.65
Loan Amount $ 388,800.00 Total Cost $ 97,200.00 4 $ 335,281.65 $ 315,295.47
5 $ 315,295.47 $ 294,129.30
Varying Interest Rate Schedule 6 $ 294,129.30 $ 271,713.49
Rate Monthly Payment Total Interest Total Cost 7 $ 271,713.49 $ 247,974.26
8 $ 247,974.26 $ 222,833.46
3.500% 9 $ 222,833.46 $ 196,208.36
3.750% 10 $ 196,208.36 $ 168,011.31
11 $ 168,011.31 $ 138,149.52
12 $ 138,149.52 $ 106,524.69
13 $ 106,524.69 $ 73,032.73
14 $ 73,032.73 $ 37,563.42
15 $ 37,563.42 $ - 0
Subtotal $ - 0 $ - 0
Down Payment
Total Cost $ - 0
Campground Research
Camp Name Firefly Pines Camp Serenity Tame River Camp Shepard
Year Purchased 2013 2010 2009 2005
Price $ 500,500.00 $ 580,000.00 $ 425,000.00 $ 320,000.00
Loan Amount $ 340,340.00 $ 487,200.00 $ 280,500.00 $ 240,000.00
Rate 5.255% 6.359% 4.586% 5.125%
Term (Years) 15 15 20 15
Monthly Payment $ 2,736.81 $ 4,206.36 $ 1,787.63 $ 1,913.57
Total Interest
Total Cost $ 500,500.00 $ 580,000.00 $ 425,000.00 $ 320,000.00
Current Year of Mortgage 5 8 9 13
Mortgage Balance at End of Current Year