Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Basic Finance Expert

[A] I have an investment of $1000 which accumulates 20 percent per year but on a DAILY basis. That means that every day the capital is rising by an additional $2.7777 [1000/360 = 2.7777]. What I need is to have M.S. Excel 2007 computing every time I open the spreadsheet how much did my investment grow. On the 3rd day it will tell me $8.3331 & the next day will automatically update to dollar 11.1108.

[B] This is the data I have:

(a) Date of purchase of the capital ($1000).

(b) Date that the capital starts to accumulate interest.

(c) Rate of the investment.

(d) Rate of interest.

(e) This is what I need: Interest growth as today.

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M920800

Have any Question? 


Related Questions in Basic Finance

Consider a two-period two-state world let the current stock

Consider a two-period, two-state world. Let the current stock price be $35 and the risk-free rate be 5%. In each period, the stock price can either go up by 10% or down by 10%. A call option expiring at the end of the se ...

One of the behavioral research case studies in this chapter

One of the Behavioral Research Case Studies in this chapter involved Agocha and Cooper's (1999) study of partner characteristics and intentions to practice safe sex. Below are the Pearson correlations between the lik ...

1 why is it important to focus on total returns when

1. Why is it important to focus on total returns when measuring an investment's performance? 2. Why do real returns matter more than nominal returns? 3. Under what conditions will the components of a bond's return have t ...

Analyze a sales letter or email you receivebe on the

Analyze a sales letter or email you receive. Be on the lookout for sales letters you receive at home or through email. Bring one to class so you can discuss the example with other students. In small groups, discuss how t ...

1 in 2009 zimbabwe ended its hyperinflation by adopting the

1. In 2009, Zimbabwe ended its hyperinflation by adopting the U.S. dollar as legal tender. What potential problems could this strategy have for the Zimbabwean government? 2. What does the statistical evidence show about ...

1 when did gnma come into existence what was its original

1. When did GNMA come into existence? What was its original function? What is its main function now? 2. What is a mortgage-related security? What are the similarities and differences between mortgage securities and corpo ...

Principles of financecorporations often use different costs

Principles of Finance Corporations often use different costs of capital for different operating divisions. Using an example, calculate the weighted cost of capital (WACC). What are some potential issues in using varying ...

A project has the following incremental cash flows for

A project has the following incremental cash flows for years zero, through year 4, respectively: -$3,000, $1,900, $900, and $800. Is 9% the IRR of this project? If not, is where is the IRR compared to 9%?

Excel assignment you are going to purchase a new house

Excel Assignment You are going to purchase a new house valued at $250,000 by making the down payment of 20% and borrowing the rest as a 30-year fixed rate mortgage of 5.25%. Solve the problem by creating an Excel spreads ...

The following information was available spot rate for

The following information was available: Spot rate for Japanese yen: $0.009313 730-day forward rate for Japanese yen: $0.010475 (assume a 365-day year) U.S. risk-free rate: 7.0 percent Japanese risk-free rate: 1.0 percen ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro