Documentation
New Perspectives Excel 2019 | Module 4: SAM Project 1a
Alanis Parks Department
ANALYZE AND CHART FINANCIAL DATA
Author: FATEMATUZ ZAHARA
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.
Spending
Alanis Parks Department
Spending on Parks, XXXXXXXXXX
Park 2018 2019 2020 2021 Trend
Carver $ 172,331 $ 178,606 $ 180,624 $ 189,794
Fern-Foley $ 225,280 $ 241,898 $ 247,033 $ 252,853
Oleander $ 302,212 $ 302,805 $ 310,247 $ 319,880
Pleistocene $ 200,098 $ 207,832 $ 221,167 $ 237,810
Sartoris $ 552,636 $ 569,846 $ 575,239 $ 586,124
Total $ 1,452,557 $ 1,500,988 $ 1,534,311 $ 1,586,460
Chart Title
Carver Fern-Foley Oleander Pleistocene Sartoris 172331 225280 302212 200098 552636
Park Spending XXXXXXXXXX
Carver 2018 2019 2020 2021 172331 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX Fern-Foley 2018 2019 2020 2021 225280 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX Oleander 2018 2019 2020 2021 302212 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX Pleistocene 2018 2019 2020 2021 200098 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX Sartoris 2018 2019 2020 2021 552636 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX Total 2018 2019 2020 2021 1452557 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX
Projection
Alanis Parks Department
Park Spending Projection
Bond Offering
Alanis Parks Department
Bond Offering Projection
Option A Option B Option C
Total Bond Revenue $575,000 $575,000 $575,000
Quarterly Interest Rate 0.0169 0.0175 0.0181
# of payments 60 60 60
Quarterly Payments ($15,314.08) ($15,555.68) ($15,799.25)
Annual Payments ($61,256.31) ($62,222.73) ($63,197.00)