Using the following data:

$$ Initial Investment $=$ $$10,000,000$

$$ Cash Inflow $$ Year $1=$ $$3,000,000$

$$ Cash Inflow $$ Year $2=$ $$3,500,000$

$$ Cash Inflow $$ Year $3=$ $$4,000,000$

$$ Cash Inflow $$ Year $4=$ $$4,900,000$

$$ Cash Inflow $$ Year $5=$ $$5,000,000$

a$.$ Calculate Internal Rate of Return

b$.$ Calculate Net Present Value $($assuming a required return of $8\%)$

Can you please complete this in Excel, with forumlas too? Thank you!!! $.$ Using the following data:

Initial Investment $=$$$10,000,000$

Cash Inflow $-$ Year $1=$$$3,000,000$

Cash Inflow $-$ Year $2=$$$3,500,000$

Cash Inflow $-$ Year $3=$$$4,000,000$

Cash Inflow $-$ Year $4=$$$4,900,000$

Cash Inflow $-$ Year $5=$$$5,000,000$

a$.$ Calculate Internal Rate of Return

b$.$ Calculate Net Present Value $($assuming a required return of $8\%)$