Questions completed and submitted on the A2 spreadsheet template through the A2 spreadsheet resignation link: 1. TVM and tie valuation questions (1 indication each): a. Your contingency congregation has debit maturing in three years (quantity shown in Table 1 on page 4 of this muniment). How abundant should the congregation objectue now in an statement paying 5% APR, compounded monthly, to determine it has adequate funds to retaliate the debit when it matures? b. Your congregation has annual unoccupied wealth as shown in Table 1. Assume this wealth conciliate advance uninterruptedly at the annual admonish shown in Table 1. What is your augury ce annual unoccupied wealth in 10 years? c. Your congregation has sepaadmonish long-term money objectuement discretions adapted to it, Objectuements A, B and C. The concern admonishs (APR) ce these discretions are loving in Table 1. What is the EAR of the objectuement discretion the congregation should adopt? d. Your congregation is buying newlightlight equipment ce the quantity loving in Table 1. To finance this, the congregation’s bank has offered an amortised advance at 4.5% APR, monthly compounding, with 20 years of monthly liquidations. What monthly liquidation conciliate the congregation keep to gain on this advance? Assume that the undiminished equipment absorb is financed and that liquidations are made at the object of each determination. e. Your congregation has an upshot of $1,000 par appraise annual coupon ties with 10 years retaining until ripeness. The annual coupon admonish is loving in Table 1, along with the vulgar cost of the ties. What is the relinquish to ripeness on the ties? f. Your congregation has an upshot of $1,000 par appraise ties with an 8% coupon admonish and quarterly coupons. The ties keep 7 years retaining until ripeness. The vulgar required yield on these ties is loving in Table 1. What is the vulgar cost of the ties?