1. Question 1 For questions 1 and 2, consider a company with the following income statement (in millions): Consider the impact of the issuance of 12B in new debt at…
5. Question 5 Suppose you have a portfolio that is 30% in the risk-free asset and 70% in a stock. The stock has a standard deviation of 0.30 (i.e., 30%)….
18. Question 18 To be eligible for discount customers must have paid before the Discount Due Date and must have paid at least the full balance owing less the discount…
20. Question 20 A valid solution for Question 19 could be achieved using which of the following combinations of functions? (Multiple answers may be correct.) 1 / 1 point  XLOOKUP and MATCH…
16. Question 16 Customers who pay 5 working days before the due date are eligible for a discount. In column M calculate the date 5 working days before the due…
13. Question 13 In column I, use the data in columns E and H to calculate how many days there were between when the invoice was issued and when it…
12. Question 12 Clear the filter you added in Question 11. In column H use the Customer Reference to look up the invoice date for that customer from the data…
10. Question 10 You would also like to see a breakdown of total outstanding fees and arrears. Start by naming the other columns in the SYS DATA sheet. Back in…
9. Question 9 The calculation in Column G has been done, it calculates the outstanding balance for each payee by adding up the fee, arrears, and other charges from the…
8. Question 8 In column F we need to get the payment amount from the BPAY sheet, but you will notice it is being treated as text because of the…
