this is a fundamentals of financial management assignment: Solve the following questions.

$1.$ Saad Jamal will secure a loan of $367585956$ PKR from BNP Paribas at an annual interest rate of $15\%$ to finance a construction project in Saudi Neom City. The project will be completed within $4$ months and is expected to generate a revenue of $95000000$ PKR each year for the next $7$ years. What will be the NPV and IRR of the Project?

$2.$ Calculate the PI of the cashflows in question $1.($Marks $3)$

$3.$ Calculate the Payback period of the cash flows in question $1.($Marks $3)$

$4.$ Calculate the modified payback period of the cash flows in question $1.($Marks $3)$

$5.$ CDA acquired a dumper at a cost of $150,000$ PKR$.$ Fifty percent of the financing was provided by United Bank through a $7-$year loan which is to be repaid in equal yearly installments over the period of $7$ years. The loan carries an interest rate of $18\%.$ What will be the remaining amount at the beginning of $4$th year. $($Marks $3)$

$6.$ You invested $18765$ PKR in the National Savings Scheme at an interest rate of $17\%$ for a period of $10$ years. What will be the value of your investment at the end of the $7$th year. $($Marks $3)$

$7.$ An investment of $17765$PKR was made at an interest rate of $19\%$ and for a period of $12$ years. What will be the value of the total amount of interest earned at the end of the $8$th year? $($Marks $3)$

$8.$ You want to invest $8780$ PKR at the start of each year in NAFA mutual funds at an interest rate of $12\%$ for the coming $10$ years. What will be the value of your investment after $8$ years? $($Marks $3)$

$9.$ You opened a retirement account with Al$-$Habib Asset Management company for a period of $13$ years. At the start of each year, you will deposit an amount of $350,000$ PKR in the account at an interest rate of $17\%$ for the first $5$ years. You will withdraw an amount of $65000$ PKR from this account during each year after the $5$th year. What will be the total amount of your investment after the thirteenth year? $($Marks $3)$

$10.$ Consider the following unconventional cash flow. What is the NPV and modified IRR $($using the terminal cash flow method$)$ of the cash flow at a cost of capital of $13\%.($Marks $3)$

Date

Cash flow

$01-$Jan$-06$

$-1,200$

$03-$Mar$-07$

$657$

$04-$Jul$-07$

$295$

$12-$Oct$-08$

$450$

$25-$Dec$-09$

do it in a way so i can write it in excel sheet

$-424$