Questions
BUSFIN 3220 AU2025 (2910) Microsoft Excel Tutorial Exam - Will be Taken in Recitation - Requires Respondus LockDown Browser
Single choice
With an applicable annual interest rate of 7%, what is the required annual payment into an investment account to have $90,000 in the investment account in ten years starting from $0 in the investment account?
Options
A.$5,714.88
B.$6,513.98
C.$7,316.49
D.$4,619.26
View Explanation
Verified Answer
Please login to view
Step-by-Step Analysis
We’re given an annual interest rate of 7% and a target future value of $90,000 after 10 years starting with $0. We need to determine the annual payment to contribute each year.
Option 1: $5,714.88. To check this, recall the formula for the future value of an ordinary annuity (payments at end of each year): FV = PMT * [((1 + r)^n − 1) / r]. Solving for PMT gives PMT = FV * r / ((1 + r)^n − 1). If we plug r = 0......Login to view full explanationLog in for full answers
We've collected over 50,000 authentic exam questions and detailed explanations from around the globe. Log in now and get instant access to the answers!
Similar Questions
(4 marks, difficulty level: Easy) Your firm plans to buy a warehouse for $150,000. The bank offers you a 25-year loan with equal annual payments and an interest rate of 10% per year. The bank requires that your firm pay 40% of the purchase price as a down payment, so you can borrow only $90,000. What is the annual loan payment?
(6 marks, difficulty level: Easy/Medium) You are thinking about buying a piece of art that costs $30,000. The art dealer is proposing the following deal: he will lend you the money, and you will repay the loan by making the same payment every 3 years for the next 24 years (i.e., a total of 8 payments). If the interest rate is 7% per year compounded annually, how much will you have to pay every three years?
(4 marks, difficulty level: Easy) Your firm plans to buy a warehouse for $150,000. The bank offers you a 35-year loan with equal annual payments and an interest rate of 14% per year. The bank requires that your firm pay 40% of the purchase price as a down payment, so you can borrow only $90,000. What is the annual loan payment?
You want to lease a computer. The lease contract is in the form of 24 equal monthly payments at an 8% APR, compounded monthly. The computer's cost of $3,600 should equal the PV of the lease payments. What will your monthly lease payments be?
More Practical Tools for Students Powered by AI Study Helper
Making Your Study Simpler
Join us and instantly unlock extensive past papers & exclusive solutions to get a head start on your studies!