# 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!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

Part of the data table (B14:H27) has been set up for you. Particularly, C14 links to the initial loan term assumption D9 and cells D14:H14 are set based on the loan term decrement assumption D10; B15 links to the initial annual interest rate assumption B9 and cells B16:B27 are set based on the initial interest increment assumption B10. Please complete the Data Table set up to calculate the monthly payments (as positive numbers) at different interest rates (B15:B27) and loan terms (C14:H14). Note: the data table is designed to be flexible, i.e., it will update automatically for any changes in the loan assumptions A9:D10. Use Conditional Formatting to format C15:H27 such that all the monthly payments that are higher than the maximum allowable monthly payment in N5 are in red color.
Solved by S. L. in 19 mins
need help with Part of the data table (B14:H27) has been set up for you. Particularly, C14 links to the initial loan term assumption D9 and cells D14:H14 are set based on the loan term decrement assumption D10; B15 links to the initial annual interest rate assumption B9 and cells B16:B27 are set based on the initial interest increment assumption B10. Please complete the Data Table set up to calculate the monthly payments (as positive numbers) at different interest rates (B15:B27) and loan terms (C14:H14). Note: the data table is designed to be flexible, i.e., it will update automatically for any changes in the loan assumptions A9:D10. Use Conditional Formatting to format C15:H27 such that all the monthly payments that are higher than the maximum allowable monthly payment in N5 are in red color.
Solved by I. H. in 13 mins
Fill in the appropriate data inputs and calculations for each option (across the row) so that all information is listed. For all options, assume that the payment period duration will be used as the compounding period and that payments are made at the end of each period. • Option 1—AD Executives Inc. has proposed a campaign costing \$45,000. This agency will accept full payment over the next two years in equal monthly installments of \$2,100. For this option, you need to calculate the annual interest rate. • Option 2—Bradshaw & Hicks has designed a campaign for \$45,000 and indicated that it will charge a 6.25% annual rate of interest on this amount, with fixed quarterly payments paid out over the next 18 months. For this option, you need to calculate periodic payments. • Option 3—AdWest Inc. has proposed the most modestly priced campaign, costing \$30,000. This agency is willing to accept monthly payments of \$1,400 until the Evaluating the Financial Impact of Loans and Investments Chapter 6 383 6Level 1 campaign is completely paid off. AdWest Inc. will charge a 6.5% annual interest rate. For this option, you need to calculate the duration in years that will be required to pay off this debt. • Option 4—Johnson, Bellview & Associates has shown the Marketing team an excellent campaign that will cost \$1,500 a month for the next two years. This agency’s payment terms are based on an annual interest rate of 5%. For this option, you need to calculate the initial value of this advertising campaign. 4. In an adjacent column, calculate the total yearly payments required for each option.
Solved by G. F. in 19 mins
Fill in the appropriate data inputs and calculations for each option (across the row) so that all information is listed. For all options, assume that the payment period duration will be used as the compounding period and that payments are made at the end of each period. • Option 1—AD Executives Inc. has proposed a campaign costing \$45,000. This agency will accept full payment over the next two years in equal monthly installments of \$2,100. For this option, you need to calculate the annual interest rate. • Option 2—Bradshaw & Hicks has designed a campaign for \$45,000 and indicated that it will charge a 6.25% annual rate of interest on this amount, with fixed quarterly payments paid out over the next 18 months. For this option, you need to calculate periodic payments. • Option 3—AdWest Inc. has proposed the most modestly priced campaign, costing \$30,000. This agency is willing to accept monthly payments of \$1,400 until the Evaluating the Financial Impact of Loans and Investments Chapter 6 383 6Level 1 campaign is completely paid off. AdWest Inc. will charge a 6.5% annual interest rate. For this option, you need to calculate the duration in years that will be required to pay off this debt. • Option 4—Johnson, Bellview & Associates has shown the Marketing team an excellent campaign that will cost \$1,500 a month for the next two years. This agency’s payment terms are based on an annual interest rate of 5%. For this option, you need to calculate the initial value of this advertising campaign. 4. In an adjacent column, calculate the total yearly payments required for each option. I attached the excel document with instructions.
Solved by K. L. in 18 mins
Part of the data table (B14:H27) has been set up for you. Particularly, C14 links to the initial loan term assumption D9 and cells D14:H14 are set based on the loan term decrement assumption D10; B15 links to the initial annual interest rate assumption B9 and cells B16:B27 are set based on the initial interest increment assumption B10. Please complete the Data Table set up to calculate the monthly payments (as positive numbers) at different interest rates (B15:B27) and loan terms (C14:H14). Note: the data table is designed to be flexible, i.e., it will update automatically for any changes in the loan assumptions A9:D10. Use Conditional Formatting to format C15:H27 such that all the monthly payments that are higher than the maximum allowable monthly payment in N5 are in red color.
Solved by Z. Y. in 18 mins
hi, I need help with how to calculate interest btw 2 periods with an annual interest rate and semi-annual compounding?
Solved by K. J. in 23 mins
I'm trying to find the equivalent interest rate (gross of 40% tax) that a bank would have to pay to achieve a known future value return from a known present value amount over a know number of years. e.g. If I start with 80,000 and end up with 1,580,000 after 7 years, (and I pay tax of 40% on the interest I earn), what gross interest must the bank pay me to end up with 1,580,000?
Solved by G. E. in 12 mins
Hi i need help with financial functions on my assignment for some parts in my seafoodloan worksheet.This is my question: You wish to make quarterly payments (4 payments per year) toward your loan repayment. You will then want to see how these payments will vary based on the number of years to repay and varying interest rates. Using the SeafoodLoan worksheet, perform the following, a)Use a annual interest rate formula in Cell C10 to calculate the annual interest rate in Cell B10. Use the appropriate relative, mixed, and/or absolute cell references.
Solved by C. S. in 16 mins
In row 4, for a \$750,000 loan at a 5.2 percent interest rate that is completely repaid with quarterly payments of \$10,000, in E4 find the number of payments that will be necessary to pay off the loan. Once E6 is complete, the value in C6 will display.
Solved by A. A. in 18 mins
In row 5, for monthly payments of \$12,000 for 10 years at a 6.15 percent interest rate, in A5 to calculate the amount the company is borrowing.
Solved by K. D. in 16 mins