Please solve in excel
Posted: Sun May 08, 2022 9:41 am
Please solve in excel
Q4 (25 pts). On December 1, your friend is going to let you borrow his Costco membership card. At Costco, you have the opportunity to buy a year's worth of popcorn for $120. Alternatively, you can buy popcorn every month at Dollar Value. Based on your receipts from last year, you predict that your popcorn purchases will be as follows: $14 Money to be Month spent on Dec $16 Jan $13 Feb $16 Mar Apr $17 May $19 Jun $16 Jul $14 Aug Sep $13 Oct $15 Nov $20 Assume that you would make your Dollar Value purchases at the beginning of each month (Dec 1, Jan 1. etc). $15 a) What is the monthly incremental rate of return? b) What is the yearly incremental rate of return?
Q4 (25 pts). On December 1, your friend is going to let you borrow his Costco membership card. At Costco, you have the opportunity to buy a year's worth of popcorn for $120. Alternatively, you can buy popcorn every month at Dollar Value. Based on your receipts from last year, you predict that your popcorn purchases will be as follows: $14 Money to be Month spent on Dec $16 Jan $13 Feb $16 Mar Apr $17 May $19 Jun $16 Jul $14 Aug Sep $13 Oct $15 Nov $20 Assume that you would make your Dollar Value purchases at the beginning of each month (Dec 1, Jan 1. etc). $15 a) What is the monthly incremental rate of return? b) What is the yearly incremental rate of return?