F C :
T J D
C -
.
H T :
T
.
Options
&
Financial
Research
a.
Purchase
of
a
12
passenger
Ford
Transit
van
$47,485
p.
Purchase
of
15
passenger
Ford
Transit
van
$49,835
c.
Lease
of
12
passenger
Ford
Transit
van
$1,325.00
monthly
p.
Purchase
of
12
passenger
Ram
Promaster
van
with
wheelchair
lift
$82,800.00
I C
Cash Flow
Net Cash Flow
Discounted Cash Flow
Net Discounted Cash Flow
Y 0
$-93,000.00
$-93,000.00
$-93,000.00
$-93,000.00
Y 1
$901,920.00
$808,920.00
$858,971.43
$765,971.43
Y 2
$928,977.60
$1,737,897.60
$842,610.07
$1,608,581.50
Y 3
$956,846.93
$2,694,744.53
$826,560.35
$2,435,141.85
Y 4
$985,552.34
$3,680,296.86
$810,816.35
$3,245,958.19
Y 5
$1,015,118.91
$4,695,415.77
$795,372.22
$4,041,330.42
AMOUNT
INVESTED:
$93,000
AMOUNT
RETURNED:
$901,920
INVESTMENT
TIME:
6/15/2022-
12/31/2026
10% I / 90% P
(C . , 2022)
I G
$808,920.00
ROI
869.81%
A ROI
64.76%
I L
4.55
Adult Care Clinic Budget
Current Year
New Budget
Comments
GROSS
REVENUE
Outpatient Revenue
Office visits
1,000,000
1,901,000
Contributions & Grants
33,046,867
37,000,000
Program Service Revenue
40,609,412
43,000,000
Investment Income
926,976
1,600,000
Diabetes education
150,000
180,000
Other Revenue
2,370,650
3,272,570
Total Gross Patient Services Revenue
78,103,905
86,773,570
EXPENSES
Grants and Similar amounts paid
14,836,872
10,400,000
Grants and assistance to domestic organizations and governments
Salaries, other compensation, employee benefits
$ 52,142,552
52,187,552
All staff salaries combined
Professional fundraising fees
$ 717,633
500,000
Total fundraising expenses
$ 2,893,874
2,800,000
Other expenses
$ 28,754,604
27,000,000
Legal, accounting, lobbying, Investment management
Total Salary Expense
$ 32,366,111
92,881,552
SUPPLIES
Medical Supplies
200,000
200,000
What is needed for the clinic to operate?
Office Supplies
100,000
80,000
What is needed for the clinic to operate?
Total Supplies
300,000
280,000
OTHER
EXPENSES
Equipment
$ 150,000.00
198,000
Includes capital expense (Transport van)
Legal Fees
$ 50,000
55,000
Repairs and Maintenance
100,000
120,000
including vehicle repairs/maintenance
Insurance
10,000
12,000
includes vehicle insurance
Fuel
20,000
Bad Debt Expense
80,000
80,000
Uncollectable accounts
TOTAL
OTHER
EXPENSES
$ 390,000
495,000
Total All Expenses
$ 33,056,111
93,656,552
Excess (Deficit) Revenues over Expenses
$ 45,047,794
-6,882,982
Achieveit.com, (2022). [Retrieved from]: https://www.achieveit.com
American Hospital Association, (2017). Social determinants of health series: Transportation and the role of hospitals. Health
Affairs Blog. [Retrieved from]: https://www.aha.org
Brock, T., & Costagliola, D., (2022). The three major financial statements: How they’re interconnected. [Retrieved from]:
https://www.investopedia.com
Charity Navigator, (2022). [Retrieved from]: https://www.charitynavigator.org
Dodge, (2022). Ram Promaster. [Retrieved from]: https://www.dodge.com
Ford, (2022). Ford Transit. [Retrieved from]: https://www.ford.com
Jane, M., (2017). Budgeting and communication. Biz fluent. [Retrieved from]: https://www.bizfluent.com
Joslin Diabetes Center, (2021). The Joslin Diabetes Center. [Retrieved from] https://www.joslin.org
Kenton, W., (2021). Strategic financial management. Corporate Finance & Accounting. [Retrieved from]:
https://www.investopedia.com
Murray, J., (2021). Capital expenses and your business taxes. Business Law & Taxes. [Retrieved from]:
https://www.thebalancesmb.com
Myers, A., (2015). Non-emergency medical transportation; A vital lifeline for a healthy community. [Retrieved from]:
https://www.ncsl.org
Nowicki, M., (2022). Introduction to the Financial Management of Healthcare Organizations, Eighth Edition: Vol. Eighth
Edition. Gateway to Healthcare Management.
O’Connell, B., (2018). What is cost of capital and why is important for business in 2019? [Retrieved from]:
https://www.thestreet.com
Rural Health Information Hub, (2022). Transportation to support rural healthcare. [Retrieved from]:
https://www.ruralhealthinfo.org
Smith, A., (2021). What is capital expenditure (CAPEX)? [Retrieved from]: https://www.investopedia.com
Watt, A., (2019). Project Management 2nd Edition. BC Campus Open Education.
