Compute the value of investment

Reference no: EM1316033

Compute the value of investment.

a ) I have an investment of $1000 (Ex.) which accumulates 20% per year but on a DAILY basis. That means that every day the capital is growing by an additional $2.7777 (1000 / 360 = 2.7777). What I need is to have Excel 2007 calculating every time i open the spreadsheet how much did my investment grow. On the third day it will tell me $8.3331 and the next day will automatically update to $11.1108.

b )This is the data I have:

1. Date of purchase of the capital ($1000).
2. Date that the capital starts to accumulate interest.
3. Value of the investment.
4. Rate of interest.
5. This is what i need: Interest growth as today.

Reference no: EM1316033

Questions Cloud

Demand for monopolist break-even point : A perfect competitive firm has the cost function TC = 1000 + 2Q + 0.1 Q^2-What is the lowest price at which the firm can break even?

Simple linear regression model using mega stats : Use MegaStat's output for simple linear regression to determine the regression equation

Relationship among variables is sufficient to warrant : Describe the data appear the strength of the relationship among variables is sufficient to warrant using linear regression forecasting.

Calculation of return on investment and residual income : Calculation of return on investment and residual income and Calculate the missing amounts for each division

Compute the value of investment : Compute the value of investment - Date of purchase of the capital and Date that the capital starts to accumulate interest

Multiple linear regression equation using mega stats : Use MegaStat's output for multiple regression to determine the multiple regression equation

Price and output determination in monopoly : RainAway, Inc., makes polymers used to coat the windshields of car's, planes, and boats-Complete the following table based on the RainAway product's price, output and costs per year:

Determine the expected return of portfolio : Determine the expected return of portfolio on the facts narrated - What is the expected return on a portfolio that is equally invested in the two assets?

Estimating probability based on the discrete distribution : The casino game craps is based on rolling two dice. Here is the assignment of probabilities to the sum of numbers on the up face when two dice are rolled:

User Account

All Pages