Get instant live Excel expert help to learn how to apply financial function in Excel?

I need help creating a pivot table with the exact instructions. i have a table with the names of teachers, students enrolled in each teachers class and the names of the assist principles with the number of teachers assigned to them. However i cant seem to get the filters to display the number of teacher assigned to each assistant principal, instead i get the number of students assigned to each assistant principal. how can i fix this? this would be for "test 5 bonus" and sheet 5 is how far I have gotten with the problem. Thank you.

I finished an amortization table excel for my excel class. The 2nd part of the question asks us to figure out the number of years and months that 1/4 of the loan is paid off, the number of years and months that 1/2 of the loan is paid off, the number of years and months that 3/4 of the loan is paid off, and the year and month when the payment is equally split between interest and principal.

In cell E11, enter a financial function to calculate the interest paid. Copy the formula to the range E12:E34. The result should be a positive value. In cell F11, enter a financial function to calculate the principal payment. Copy the function to the range F12:F34. The result should be a positive value. In cell G11, enter a formula to calculate the ending balance. Copy the formula to the range G12:G34. Adjust the width of column G, if needed, to display the values. Select the range D11:G34 and apply Accounting Number Format.

Tab "Historical Loan Tapes": I need to calculate (total sum of Unpaid Principal Balance (column S) if column BD is present (Foreclosure/Pre-Foreclosure), with reference to originator(AO). I need the result of this formula in cell E25 in tab "Lender Loan Tape Summary"

present value formula excel won't work for each cash flow for annuity and single PV

How do you calculate the present value excel of future payments that do no start for 3 years?

i need a future value calculator excel to sum up all future values computed. for example i need to compute total amount of wages one can earn for 34 years at a 2% increase for each year based on the present value

I need to find the Total of all Payments in a problem regarding car loans and down payments and such. How do I calculate the total of all payments (I have the price of the car, the down payment amount, the amount financed, the present value and the PMT).

Financial Excel Formula : I need a spreadsheet to calculate NPV (net present value) for a project at 1% intervals (1% through 15% discount rate). Here are the givens: Investment: -$11,000 and Cash Flows for Years 1 through 5 of $4,000 each year.

Financial Excel Formula Needed on a Spreadsheet that can calculate NPV of an investment of $11,000 using a discount rate of 1% and a cash flow of $4,000 per year for 5 years. The formula needed will allow me to change the discount rate and cash flow to accommodate different scenarios of NPV (net present value) calculations of an investment.