(a) If Project A is completed today, its required payment is $90,000. However, investors decided to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
(a) If Project A is completed today, its required payment is $90,000. However, investors decided to pay off the project only at the end of year 3. The required payment for the project will increase by 4% every year. With this in mind, the investors will deposit an investment amount to a bank account with an interest rate of 7% per year. The deposits will occur at the end of year 1, year 2, and year 3, respectively. Information about this project is shown in the figure below: A 1 Required payment (present value) 2 Rate of increase per year if payment is not paid off 3 Account interest rate per year 4 Year of pay off 5 6 7 Required payment 3 years later (using FV function) 8 Required deposit at end of each year (using PMT function) 9 10 11 12 13 14 15 B $90,000.00 4.00% 7.00% C Year Deposit at end of year Accumulated account balance at end of year 1 2 3 Round your answers to two (2) decimal points. Calculate the project payment amount if it will only be paid three years later and the required deposit at the end of each year if investors were to settle this payment at the end of year 3. State the Excel formula for Cell B7 and Cell B8. Write down the Excel formulas for Cells B13:C15. (a) If Project A is completed today, its required payment is $90,000. However, investors decided to pay off the project only at the end of year 3. The required payment for the project will increase by 4% every year. With this in mind, the investors will deposit an investment amount to a bank account with an interest rate of 7% per year. The deposits will occur at the end of year 1, year 2, and year 3, respectively. Information about this project is shown in the figure below: A 1 Required payment (present value) 2 Rate of increase per year if payment is not paid off 3 Account interest rate per year 4 Year of pay off 5 6 7 Required payment 3 years later (using FV function) 8 Required deposit at end of each year (using PMT function) 9 10 11 12 13 14 15 B $90,000.00 4.00% 7.00% C Year Deposit at end of year Accumulated account balance at end of year 1 2 3 Round your answers to two (2) decimal points. Calculate the project payment amount if it will only be paid three years later and the required deposit at the end of each year if investors were to settle this payment at the end of year 3. State the Excel formula for Cell B7 and Cell B8. Write down the Excel formulas for Cells B13:C15.
Expert Answer:
Answer rating: 100% (QA)
Solution a Project Payment and Deposits 1 Project Payment at Year 3 Cell B7 We need to find the Future Value FV of the initial 90000 considering a 4 a... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
Carol Harris, Ph.D, CPA, is a single taxpayer and she lives at 674 Yankee Street, Durham, NC 27409. Her Social Security number is 793-52-4335. Carol is an Associate Professor of Accounting at a local...
-
Determine the transfer function from U(s) to Y(s) for the following block diagram. Provided are some recommended steps to take: a. Label each signal (line with arrow) b. Write the equation for each...
-
Use any method to determine if the series converges or diverges. Give reasons for your answer. n10 10" n=1
-
Will a monopoly that maximizes profit also be maximizing revenue? Will it be maximizing output? Briefly explain.
-
Drabinski Ltd. decided on 1 July 20X3 to dispose of an asset group consisting of land, a building, and equipment. An active plan of disposal is being carried out, and sale is highly probable within...
-
Managers seem to be concerned about EBITDA quite a bit. What is it that EBITDA really communicates to managers?
-
The Cincinnati Zoo and Botanical Gardens had a record attendance of 1.87 million visitors in 2017 (Cincinnati Business Courier website). Nonprofit organizations such as zoos and museums are becoming...
-
In Marigold Company, the Cutting Department had beginning work in process Inventory of 4000 units, completed and transferred out 26000 units, and fiad an ending work in process inventory of 3500...
-
1. Since Mr. Snodgrass doesnt have any historical data, (only an estimate of the number of customers hell serve each month), which specific type of qualitative method is he using? What would be the...
-
In the circuit shown, if a conducting wire is connected between points A and B, the current in this wire will 40 (b) be zero (c) flow from B to A (d) flow from A to B 192" B 402 302 (a) flow in the...
-
What are various certifications available for accountants? Briefly explain each certification.
-
Vivians Online Video currently has a return on assets of 10%. Indicate the effects of the following business transactions on the Vivians Online Video return on assets. Consider each transaction...
-
Posting a $2,500 purchase of office supplies on account appears as follows: a. b. C. d. Cash 2,500 Office Supplies 2,500 Office Supplies 2,500 Office Supplies 2,500 Office Supplies 2,500 Accounts...
-
Which of the following statements concerning reversing entries is true? a. Reversing entries are required by Generally Accepted Accounting Principles (GAAP). b. Reversing entries are most often used...
-
Assets are listed on the balance sheet in the order of their a. purchase date. b. adjustments. c. liquidity. d. balance.
-
For the last three years, youve been working as an accountant at the U.S. headquarters of Exottica Eyewear, a large multinational company that owns several popular chains of eyewear stores. Given...
-
Provide an example of an aggressive accounting practice. Why is this practice aggressive?
-
What is an income trust? What are the major categories of income trusts? What are real estate investment trusts (REITs)? What are some attractive characteristics of REITs?
-
What is the liquidity ratio? Is it better to have a high or low liquidity ratio? Explain.
-
Does your benefit decrease and/or increase if you receive your CPP pension sooner and/or later? Explain.
-
A gene is a segment of DNA that contains the information to produce a functional product. The functional product of most genes is a. DNA. b. mRNA. c. a polypeptide. d. none of the above.
-
Which of the following is not a constituent of a cells proteome? a. An enzyme b. A cytoskeletal protein c. A transport protein in the plasma membrane d. An mRNA
-
The function of the genetic code is to a. promote transcription. b. specify the amino acids within a polypeptide. c. alter the sequence of DNA. d. do none of the above.
Study smarter with the SolutionInn App