Purchase Solution

Excel to determine a value

Not what you're looking for?

Ask Custom Question

Please see attached file.

In finance one sees equations like: 160000 = 100((1+i)360 - 1)/i
Determine the value of i.

Attachments
Purchase this Solution
Solution Summary

This shows how to determine the value of a variable using Excel.

Purchase this Solution
Free BrainMass Quizzes
Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

View More Free Quizzes
Related BrainMass Solutions

  • Random Samples from Two Binomials

    Random samples from two binomial populations produced the following statistics: P hat 1 = .45 n1 = 100 p hat2 = .40 n2 = 100 a) Calculate the p-value of a test to determine whether we can infer that the population proportions

  • Calculating the Value of an Annuity

    RATE) to determine the interest rate you would need to achieve $50,000 in ten years with a annual payment of $4000 and $3,500 up front. f) Use an Excel function (e.g.

  • Interest Rate

    You can either use a financial calculator or excel to determine that. I'll show you Excel formulas.

  • The following sample observations were randomly selected.

    X: 5, 3, 6, 3, 4, 4, 6, 8 Y: 13, 15, 7, 12, 13, 11, 9, 5 a. Determine the regression equation. b. Determine the value of Y' when X is 7. Please see the attached Excel file.

  • Hypothesis testing problems

    Conduct a test of hypothesis to determine the mean age is less than 40. Use the .05 significance level. Determine the p value and interpret the results. d.

  • Statistics

    196394 A "what if analysis" designed to determine what happens to the test statistics and interval estimates when elements of the statistical inference change. This can be solved manually or on Excel with Test statistics or Estimators workbook.

  • Short Term Notes Payable

    Excel shows July 22, November 12 and January 20 Determine the interest due at maturity for each of the three notes. (Assume a 360-day year.)

  • Calculating Net Value Present and IRR

    Use the formula and the financial calculator or Excel to determine: Given three projects with the following cash flows: Project A Project B Project C Year Cash Flow Cash Flow Cash Flow 0 -1000 -1000 -1000 1 200 500 350 2 300 400 350 3

  • Bond Prices

    You can use the following formula in Excel: =RATE(Periods,Payment,Price,Par Value) =RATE(20,0.07*1000,-875,1000) = 8% B) Determine the value of the bond to you, given your required rate of return This you can do using a formula.

View More Related Solutions