Share
Explore BrainMass

Bank Loan Calculations Using MS Office 2007

This file contains a formatted MS Excel spreadsheet containing "What IF" amortization tables for determination of the "best" bank loan.

Attachments

Solution Preview

Please find attached a formatted MS Excel 2007 file which addresses the issues in your post.

Loan Conclusions

Bank Loan 1 Bank Loan 2 Difference

Totals: $1,668,318.32 $1,657,491.83 $10,826.49

1.) Bank Loan 2 is the better ...

Solution Summary

This file contains a formatted MS Excel spreadsheet containing "What IF" amortization tables for determination of the "best" bank loan.

$2.19