“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

hi, can you show me the formula to calculate the discount rate in cell G2 from discount spreadsheet

Solved by E. E. in 25 mins

Financial Excel Formula Needed on a Spreadsheet that can calculate NPV of an investment of $11,000 using a discount rate of 1%.

Solved by X. H. in 18 mins

In cell G6, enter a formula that calculates the Discount Rate for the Off-Peak rental price per day. For example, using the peak and off-peak per day values, the studio apartment rents for 80% of its peak rental rate. However, you need to calculate and display the off-peak discount rate, which is .19973.

Solved by F. H. in 27 mins

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.

Solved by T. S. in 16 mins

Hi, i would like to add a discount rate (%) column in the sales worksheet, can you help me to solve this? i should use if function right?

Solved by E. Y. in 26 mins