Explore BrainMass
Share

Bank Loan Calculations Using MS Office 2007

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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

See the attachment.

© BrainMass Inc. brainmass.com October 24, 2018, 10:14 pm ad1c9bdddf
https://brainmass.com/computer-science/software-development/bank-loan-calculations-office-152732

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 ...

Solution Summary

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

$2.19
See Also This Related BrainMass Solution

Evaluating a Financial report - Kroger

I am looking for some help with putting together information on The Kroger Co.'s last two annual reports. I need to compute the eight ratios listed below for two consecutive years, discuss their
significance for management and compare them to industry averages.

Current Ratio
Quick Ratio
Inventory Turnover Ratio
Debt Ratio
Net Profit Margin Ratio
ROI
ROE
Price-to-Earnings Ratio (P/E) Ratio

I need help trying to analyze Kroger's working capital management. Explaining why the companyÂ's operating and cash cycles are currently optimized. Based on Kroger's last two financial statements, I need information on the long-term debt held by the corporation, maturity dates and yield to maturity.

I must list the types of stock issued by the company, the stocks' current selling price, and the 52-week average selling price, compute the weighted average cost of capital (WACC) for both years and discuss my findings.

My information must include a brief analysis that summarizes the data gathered and evaluates how Kroger compares to industry averages.
Should I buy this company's stock and why?

All I have for reference is :
http://www.annualreports.com where one of the other reports can be found and the attached. Kroger's 2007 Annual report is on page 74.

View Full Posting Details