The link provided above shows you how to turn Excel into a Financial Calculator.
Your question is a little more advanced because of the specific dates involved..
but If I simplified the 1st question and used the FV function in Excel this is what i would do:
What to include in the excel cell:
I would included the following:
rate = 2% fairly straightforward..
nper = 1.5 number of payments.. it's for a period of one and a half years.. Its actually 2 payments, 1 each year, compounding 1 time each year.. so you could put 2
pmt = 0 (you aren't recieving or contributing payments)
pv = -10,000,000 The present value of the investment, on a financial caluculator this would be -10,000,000 because the money is going out of your pocket..
type = leave this out
=FV(2%, 1.5, 0, -10000000) that should equal 10,301,495.04 Thats according to my financial calculator.. if you replace nper 1.5 with 2 then you get 10404000.00
You could also calculate Future Value (FV) of the first 3 months with a different interest rate (the interest rate for 3 months, instead of a year) Then you just need to do 3 future value functions, with the result of each one becoming the present value of the next (pv)
The function for your second question would be Rate(nper,pmt,pv,fv,type,guess)
You can ignore the type and guess part..
I would enter into an encel cell:
=Rate(1.5, 0, -10000000, 10300000)
this assumes that payments are once per year, and compounding is once per year:
n (number of payments) = 1.5 (1 and a half years)
pmt = 0 (you are not making or recieving payments)
pv = -10000000 (the present value of your investment, it's negative, because you don't have the money in your pocket)
fv = 10300000 (the future value that you want)
The result in a financial calculator is 1.990131 it will round it to 2% probably.. in excel.. you'll want to make sure the format allows for decimal places to get accurate numbers..
Edit: I noticed that my version of Excel (2010) had all the proper financial calculations and instructions on how to use them. The FV function rate, would be the percentage for the year, divided by how often you pay during the year. Type is Begin or End mode. It functions identically with a financial calculator when you use it.