Build: Start with a Small Version If the model is complicated, start with a small, readily manageable version of the model. First make sure you've got the logic of the model worked out correctly for the small version. Only then expand it to full size. B D E F G H 1 J K L LT Rate ST Rate 5% 7% Start Balance Minimum Cash 1 0.5 (all cash figures in millions of dollars) 3 4 5 6 7 8 9 10 11 12 LT Interest LT Loan 6 ST Interest Cash Flow -8 -2 Year 2018 2019 ST Loan 2 5 LT ST Payback Payback Ending Balance 1.00 1.56 Minimum Balance 0.5 0.5 > -0.30 -0.14 -2.00 > H 1 J KI L F G 8 9 LT ST 10 Interest Interest 11 12 --LTRate LTLoan =-STRate 'E 11 LT ST Ending Minimum Payback Payback Balance Balance =StartBalance+SUM(C 11:111 >= =MinimumCash =-E11 =J 11+SUM(C12.112) >= =MinimumCash Build: Start with a Small Version If the model is complicated, start with a small, readily manageable version of the model. First make sure you've got the logic of the model worked out correctly for the small version. Only then expand it to full size. B D E F G H 1 J K L LT Rate ST Rate 5% 7% Start Balance Minimum Cash 1 0.5 (all cash figures in millions of dollars) 3 4 5 6 7 8 9 10 11 12 LT Interest LT Loan 6 ST Interest Cash Flow -8 -2 Year 2018 2019 ST Loan 2 5 LT ST Payback Payback Ending Balance 1.00 1.56 Minimum Balance 0.5 0.5 > -0.30 -0.14 -2.00 > H 1 J KI L F G 8 9 LT ST 10 Interest Interest 11 12 --LTRate LTLoan =-STRate 'E 11 LT ST Ending Minimum Payback Payback Balance Balance =StartBalance+SUM(C 11:111 >= =MinimumCash =-E11 =J 11+SUM(C12.112) >= =MinimumCash