Instruction: Please use only the Excel Spreadsheet I provided here.

On the Excel Spread Sheet: Tab 1 is for Question 1, Tab 2 is for Question 2 , Tabs 3 and 4 are for Question 3, Once you are done, please submit it at the Moodle.

Question 1 . Please create an excel invoice model professionally with following conditions:

-You as a banking officer of Queensbury Bank (address: 10 N. West Street, Queensbury, N.Y. 12804. Your customers name is Plattsburgh Corporation (address: 20 South Street, Plattsburgh, N.Y. 12810)

-The loan amount is $2,500,000.00, interest for 2.5 %, Period from 9/8/20 to 9/29/20

-The loan amount is $2,000,000.00, interest for 1.25% Period from 9/27/20 to 12/1/20

Question 2 . Please create an excel model with the following conditions professionally:

2.1 What is the amount of future value on current amount of $1,000.00 for two years with 4.5 % of interest.

2.2 What is the amount of present value on future amount of $5,400.00 for two years with 4.5 % of interest.

2.3 What is the amount of annuity value on current amount of $1,000.00 for two years with 4.5 % of interest.

Question 3. Please create advance and paydown/payment excel activities and cover page as instructed in class with following conditions professionally:

Goodwill Company:

-3 advances for $1,000,000 (date 9/1/20), $505,000(date 9/3/20), and $235,000.00(date 9/5/20)

-2 paydowns/payments for $1,400,000.00(date 9/4/20) and $345,000.00(date 9/6/20)

-Please make sure to display the correct balance that matches the amount on cover page.