Laserfiche WebLink
Farmers Pawnee Canal Company Agenda Item 23b <br />September 9, 2008 <br />Page 4 of 5 <br />Financial Analysis <br />TABLE 1 <br />FINANCIAL SUMMARY <br />PROJECT/LOAN <br />Total Project Cost $250,000 <br />CWCB Loan (90% of the Project cost) $225,000 <br />CWCB Loan (Including 1% Service Fee) $227,250 <br />CWCB Annual Loan Payment $10,857 <br />CWCB Loan Obligation (including 10% debt reserve funding) $11,943 <br />Number of Shareholders 110 <br />Numbers of Shares 500 <br />Annual Cost Per Share for Project $24 <br />Annual Cost of Loan per AF (based on 27,260 AF average diversion) $0.44 <br />Creditworthiness : The Company’s current assessment is $190/share. Rates will need to be <br />increased to $214/share to cove r the new CWCB debt service. The Company has an existing <br />CWCB loan for rehabilitation of its diversion dam and headgate structure. That loan was for <br />$29,000 to stabilize the headgate after flood da mage in 1997. There is one $2,600 payment <br />remaining. The Company has a good history with the CWCB and made all payments on time. <br />TABLE 2 <br />FINANCIAL SUMMARY <br />Future <br />Past 2 Years <br />Financial Ratio <br />w/ Project <br />99% 111% <br />Operating Ratio (revenues/expenses) <br />(Weak) (Average) <br /> weak: <100% - average: 100% - 120% - strong: >120% <br />$96/97K $108/97K <br />Debt Service Coverage Ratio <br />47% 100% <br />(revenues-expenses)/debt service <br />(Weak) (Average) <br />96-97/2.6K $108-97/11K <br /> weak: <100% - average: 100% - 120% - strong: >120% <br />18% 15% <br />Cash Reserves to Current Expenses <br />(Weak) (Weak) <br /> weak: <50% - average: 50% - 100% - strong: >100% <br />$19/104K $16/108K <br />$3.67 $4.09 <br />Annual Operating Cost per Acre-Foot <br /> (27,260 AF) <br />(Strong) (Strong) <br />weak: >$20 - average: $10 - $20 - strong: <$10 <br />$100K/27K AF $108K/27K AF <br />