Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help me with fill this excel and answers for a,b,c thank you. 2) PROBLEM 2: COMPOUND INTEREST A generous investor is very impressed by

image text in transcribedimage text in transcribed

Please help me with fill this excel and answers for a,b,c thank you.

2) PROBLEM 2: COMPOUND INTEREST A generous investor is very impressed by WinTech's single board computers and offers a loan at 6% compounded annually to expand the facility so that SBCs can be produced more rapidly. Furthermore, the investor is willing to wait two years before being repaid. After two years, increased sales allow WinTech to accumulate significant savings, and $1000(80 + A - B - C + D) is used to pay off the entire debt to the investor. Again, this equation is completed using the designated values from your student number. On the "Problem 2" worksheet, enter values and formulas to answer the following: a) What was the initial loan amount provided by the investor and what was the accumulated interest over the two- year period? b) If the investment had not been repaid as suggested previously, how long would it have taken to accumulate a debt of $100,000 with the interested being compounded annually (using the same interest rate of 6%)? c) Using the initial loan balance calculated in a), how much would have been repaid, in two years, if it had been issued at a monthly compounding frequency instead of an annual compounding frequency ? Compare your answer to (a). A B C D E TI G A= 6 - 1 - 0 B= 7 Amount to pay off debt = 77000 Initial loan = = Accumulated Interest = Time to reach $100k of debt = Loan accumlation of compounded monthly = O NO C= 2 D= 00 vauw NP 5 0 0 - 8

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

How To Value Buy Or Sell A Financial Advisory Practice

Authors: Mark C. Tibergien, Owen Dahl

1st Edition

1576601749, 978-1576601747

More Books

Students also viewed these Finance questions