Get instant live Excel expert help to learn how to apply financial function in Excel?
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Trying to solve interest due (12 month compounding) using principal and interest calculator
Investments have been made over different times before 12/31/17
Principal will be paid prorata over 12 months in 2018
Accrued interest be paid prorata over first 3 months in 2019
Solved by K. J. in 20 mins
Enter a function in cell E12, based on the payment and loan details, that calculates the amount of principal paid on the first payment. Be sure to use the appropriate absolute, relative, or mixed cell references.
Solved by M. A. in 26 mins
Enter a formula in cell F12 to calculate the remaining balance after the current payment. The remaining balance is calculated by subtracting the principal payment from the balance in column B.
Solved by D. B. in 19 mins
Enter a function in cell H12, based on the payment and loan details, that calculates the amount of cumulative principal paid on the first payment. Be sure to use the appropriate absolute, relative, or mixed cell references.
Enter a reference to the remaining balance of payment 1 in cell B13. Use the fill handle to copy the functions created in the prior steps down to complete the amortization table.
Solved by S. Q. in 25 mins
Architecture Interior Design Combined Hourly Rate
Principal 15 5 18 $150
Sr. designer 25 35 40 $110
Drafter 40 30 60 $75
Administrator 5 5 8 $50
Solved by S. H. in 24 mins
I need to find the maturity value using the Excel 365. I have the simple interest (SI) as $180, Principal as $1200, rate as 5%, and time at 3 years.
Solved by O. E. in 18 mins
How to use a function like "IF" for multiple criteria's?
In the attached file I want to add if in column D there is the word "Principal" or "Commission" then it should give me the sum of column H otherwise should be number of 0
Solved by O. C. in 11 mins
I want to know how to do IRR. So if my capital flows are the following:
Jan 1 Year 1 -15,208,000 (principal investment)
Dec 31, Year 1 - -30,531 loss
Dec 31 Year 2 11,335,135 profit
Dec 31 Year 3, 20,696,722 Profit
The question I have is in excel should the the first square only -15,208,000 or should I add -30,531 or should they be separated because the -15,208,000 is the principal investment and -30,531 is the initial loss in year 1.
Solved by Z. H. in 17 mins
I need a formula for computing an amortization schedule of Interest= Principal x Interest x t (which = 1/12)
Principal = 179,920
Interest = 5.5%
Solved by T. J. in 14 mins
In cell D12, enter a function to calculate the first principal payment. Format the cell as Currency with 2 decimal places.
Solved by I. Y. in 30 mins