As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this howto. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 30th installment in his "Excel Business Math" series of free video lessons, you'll learn how to solve business math word problems that involve rate of change (increase or decrease).
 Hot
 Latest

How To: Find a PValue with Excel

How To: Enter formulas in Excel with a macro

How To: Calculate APR, EAR & period rates in Microsoft Excel 2010

How To: Make calculations for 30 day months in Microsoft Excel

How To: Create a Basic Attendance Sheet in Excel

How To: Extract records that meet certain criteria in Excel

How To: Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'

How To: Update inventory records by formula in Microsoft Excel

How To: Create a percentage frequency table in Microsoft Excel

How To: Clear data & cell contents in Excel using a macro

How To: Create a Tangent Line with Excel

How To: Create an Excel spreadsheet to calculate your GPA

How To: Graph the probability density function in an Excel file

How To: Crosscheck two lists for discrepancies in MS Excel

How To: Create a multiuser login system in Microsoft Access

How To: Convert hours to days & days to hours with Excel's MOD

How To: Print doublesided and reverse printing order in Word

How To: Identify the first occurrence of a value in a column in Microsoft Excel

How To: Download & install the Microsoft Excel MoreFunc addin

How To: Remove tabs & scroll bars from an Excel spreadsheet

How To: Find a PValue with Excel

How To: Enter formulas in Excel with a macro

How To: Calculate APR, EAR & period rates in Microsoft Excel 2010

How To: Make calculations for 30 day months in Microsoft Excel

How To: Create a Basic Attendance Sheet in Excel

How To: Extract records that meet certain criteria in Excel

How To: Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'

How To: Update inventory records by formula in Microsoft Excel

How To: Create a percentage frequency table in Microsoft Excel

How To: Clear data & cell contents in Excel using a macro

How To: Create a Tangent Line with Excel

How To: Create an Excel spreadsheet to calculate your GPA

How To: Graph the probability density function in an Excel file

How To: Crosscheck two lists for discrepancies in MS Excel

How To: Create a multiuser login system in Microsoft Access

How To: Convert hours to days & days to hours with Excel's MOD

How To: Print doublesided and reverse printing order in Word

How To: Identify the first occurrence of a value in a column in Microsoft Excel

How To: Download & install the Microsoft Excel MoreFunc addin

How To: Remove tabs & scroll bars from an Excel spreadsheet
1 Comment
Dear WonderHowTo users,
I have buiness math project and I need for help how to solve it on Excel
and this is the project:
Athena secured a 5/1 adjustable rate mortgage (ARM) loan 5 years ago. The amount of the loan was $N (where N = six last digits of your student ID number) for K years (where K = your age), with interest rate 5.50%/year compounded annually. Currently, the interest rate for their ARM (after the reset) is 6.50% compounded annually. (Athena will continue making these new payments for K5 years until the loan is amortized).
a) What was the annual payment during the first 5 years?
b) What is remaining principal on the loan?
c) What is the new annual payment?
d) Compute the total interest paid over the life of both parts of the loan.
Based on your computations, set up an excel spreadsheet table that records the amount of the outstanding principal, interest and payments in each period and compute the total interest paid over the life of both loans by adding numbers in the interest column.
the doctor gave us today and tomorrow last day for to submit
thanks
Share Your Thoughts