1. Your corporation currently has 200,000 shares of stock outstanding that sells for $50.00 per share. What will be the amount of shares outstanding and the share price after the stock split. Please show your calculation. Your corporation has declared a five- for-four stock split.

2. Imagine that you borrowed $40,000 through a home equity loan with a variable rate. The loan is non-amortizing (the payment will be only interest now, with the principle being paid in a lump- sum at the end of the loan term). The monthly payment will be based on the smaller of: 1) The prime rate, or, 2) 6.25% APR

Create a VBA function to calculate the loan’s payment. Test it out on the dataset provided.