Finance Data

Attached is a spreadsheet with financial data.

The first dataset involves data on sales growth for 35 companies in a growth fund and 35 companies in a value fund.  Fund  number one is the the growth fund.  Fund number two is the value fund.   The data is year over year for the most recent quarter, usually the third quarter of 2017.

 

Go here for this sales growth data:

sales growth

Using Excel to Calculate Mortgage Qualification Amounts

The attached spreadsheet shows how to use an Excel spreadsheet to calculate the amount of mortgage a person with student or consumer debt might qualify for.   One scenario estimates the impact of increasing maturity of student loan from 10 years to 20 years on increase in potential mortgage and cost to student borrower.

Examples of solving for mortgage qualification amounts in Excel.

qualification-for-house-by-student-borrower (3)