macattack003
New Member
- Joined
- Mar 23, 2011
- Messages
- 4
I'm completely lost with these functions because i've read the explanations of how to plug in which numbers but I'm not to sure if i did it right or if i have the right information
Create a worksheet that will figure the bi-annual payment for a business loan. Interest Rate is 6.8%, Years of loan is 30, and total loan is 750,000. Make sure you include all information necessary in the worksheet and make sure everything is labeled. Figure the principal on payment number 60. (Hint: this is PPMT) You must use the PMT and PPMT function on this worksheet. You may not use one of the pre-existing Excel templates, you must create from a blank worksheet
Create a worksheet that will figure the bi-annual payment for a business loan. Interest Rate is 6.8%, Years of loan is 30, and total loan is 750,000. Make sure you include all information necessary in the worksheet and make sure everything is labeled. Figure the principal on payment number 60. (Hint: this is PPMT) You must use the PMT and PPMT function on this worksheet. You may not use one of the pre-existing Excel templates, you must create from a blank worksheet
Last edited:
