Seeking excel formula that calculates lease and balloon payments

[Big Al]

I am seeking an excel formula that will calculate plant and equipment lease
instalment, then separate the instalments into the interest, and GST
components. Then calculate the balloon payment due at the end of the leasing
period

 

[Gary''s Student]

start here:

http://office.microsoft.com/en-us/templates/results.aspx?qu=equipment+lease&av=TPL000