Question: Hi, please help me step by step complete question a. . ome Insert Page Layout Formulas Data Review View B C G H 1 J

Hi, please help me step by step complete question a.

Hi, please help me step by step complete question a. . ome

Insert Page Layout Formulas Data Review View B C G H 1

J K M N On 1 March 2018 an investor deposits R65,000

into a savings account which earns interest at a rate of 6.62%

per year, compounded quarterly. The investor decides to invest an additional amount

ome Insert Page Layout Formulas Data Review View B C G H 1 J K M N On 1 March 2018 an investor deposits R65,000 into a savings account which earns interest at a rate of 6.62% per year, compounded quarterly. The investor decides to invest an additional amount of R764 at the end of each month into the savings account. The monthly investments will be made for a total of 8 years. Fill in the given table and show (on the table) when the investor would have tripled his initial investment. (Colour the date.) b Test your answer in a by calculating how long it will take the investor to triple his initial investment. (Use the formulas in your studyguide to calculate the answer.) Assume now that the investor wants to double his initial investment in 3.75 years. Calculate the monthly payment necessary to achieve this. a C Rentekoers / Interest Rate Aanvanklike Belegging / Initial Investment Quarterly Monthly Maandelikse Belegging / Monthly Investment P)/p = Pl/p = Antwoord (Datum) / Answer (Date) p= p = Datum / Date Begin Rente Ontvang / Interest Received Einde / End Mar 2018 Apr 2018 May 2018 Jun 2018 Jul 2018 Aug 2018 Sep 2018 Oct 2018 Nov 2018 Dec 2018 Jan 2019 Feb 2019 Mar 2019 Apr 2019 May 2019 Jun 2019 Jul 2019 Aug 2019 Sep 2019 Oct 2019 Nov 2019 Dec 2019 Jan 2020 Feb 2020 Mar 2020 Apr 2020 May 2020 Jun 2020 Jul 2020 Aug 2020 Sep 2020 Oct 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 | Mar 2021 f RE Apr 2021 May 2021 Jun 2021 Jul 2021 Aug 2021 Sep 2021 Oct 2021 Nov 2021 Dec 2021 Jan 2022 Feb 2022 Mar 2022 Apr 2022 May 2022 Jun 2022 Jul 2022 Aug 2022 Sep 2022 Oct 2022 Nov 2022 Dec 2022 Jan 2023 Feb 2023 Mar 2023 Apr 2023 May 2023 Jun 2023 Jul 2023 Aug 2023 Sep 2023 Oct 2023 Nov 2023 Dec 2023 Jan 2024 Feb 2024 Mar 2024 Apr 2024 May 2024 Jun 2024 Jul 2024 Jul 2024 Aug 2024 Sep 2024 Oct 2024 Nov 2024 Dec 2024 Jan 2025 Feb 2025 Mar 2025 Apr 2025 May 2025 Jun 2025 Jul 2025 Aug 2025 Sep 2025 Oct 2025 Nov 2025 Dec 2025 Jan 2026 Feb 2026 ome Insert Page Layout Formulas Data Review View B C G H 1 J K M N On 1 March 2018 an investor deposits R65,000 into a savings account which earns interest at a rate of 6.62% per year, compounded quarterly. The investor decides to invest an additional amount of R764 at the end of each month into the savings account. The monthly investments will be made for a total of 8 years. Fill in the given table and show (on the table) when the investor would have tripled his initial investment. (Colour the date.) b Test your answer in a by calculating how long it will take the investor to triple his initial investment. (Use the formulas in your studyguide to calculate the answer.) Assume now that the investor wants to double his initial investment in 3.75 years. Calculate the monthly payment necessary to achieve this. a C Rentekoers / Interest Rate Aanvanklike Belegging / Initial Investment Quarterly Monthly Maandelikse Belegging / Monthly Investment P)/p = Pl/p = Antwoord (Datum) / Answer (Date) p= p = Datum / Date Begin Rente Ontvang / Interest Received Einde / End Mar 2018 Apr 2018 May 2018 Jun 2018 Jul 2018 Aug 2018 Sep 2018 Oct 2018 Nov 2018 Dec 2018 Jan 2019 Feb 2019 Mar 2019 Apr 2019 May 2019 Jun 2019 Jul 2019 Aug 2019 Sep 2019 Oct 2019 Nov 2019 Dec 2019 Jan 2020 Feb 2020 Mar 2020 Apr 2020 May 2020 Jun 2020 Jul 2020 Aug 2020 Sep 2020 Oct 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 | Mar 2021 f RE Apr 2021 May 2021 Jun 2021 Jul 2021 Aug 2021 Sep 2021 Oct 2021 Nov 2021 Dec 2021 Jan 2022 Feb 2022 Mar 2022 Apr 2022 May 2022 Jun 2022 Jul 2022 Aug 2022 Sep 2022 Oct 2022 Nov 2022 Dec 2022 Jan 2023 Feb 2023 Mar 2023 Apr 2023 May 2023 Jun 2023 Jul 2023 Aug 2023 Sep 2023 Oct 2023 Nov 2023 Dec 2023 Jan 2024 Feb 2024 Mar 2024 Apr 2024 May 2024 Jun 2024 Jul 2024 Jul 2024 Aug 2024 Sep 2024 Oct 2024 Nov 2024 Dec 2024 Jan 2025 Feb 2025 Mar 2025 Apr 2025 May 2025 Jun 2025 Jul 2025 Aug 2025 Sep 2025 Oct 2025 Nov 2025 Dec 2025 Jan 2026 Feb 2026

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

An Introduction to Management Science, 14th Edition, Chapter 15, appendix 15.1, pages 785-786; I have completed this spreadsheet 15 times, everything matches the book, but the book answer is 7.19...

all answers must be entered as formulas Building a balance sheet- Excel X FILE OME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calbri A A 11 % Alignment Number Conditional Format as Cell...

I need help on the question 2 that is in the excel file. I need to know the formula for finding out how many shares would be purchased by the investment of 1,200. Also how can I tell which one is an...

Hi, please help me step by step complete scenario 3. . Home Insert Page Layout Formulas Data Review View A1 B C D E F G K M N R O Q A friend of yours opens a savings account and immediately invests...

Ch. 9 Homework A Saved Help Save & Exit Submit ID JLCIURUS LALE FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In 2 X Calibri 11 - A A % - Paste A Cells Alignment Number Conditional...

4. Suppose that Jenna just bought a newly issued 15-year bond with a coupon rate equal to 7%. If Jenna sells the bond at the end of the year when the market price is $917, what would be the bond's...

i tried pv=fv/(1+r)^n bug it didnt work!!? Saved Help Save & Exit Calculating present values - Excel ? FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sic Ariel - 12 A A 96 25 Paste B TV -...

Calculating relevant cash flows - Excel - OME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW S Calibri 11 A A % BIU- Alignment Number Cells Editing Conditional Format as Cell Formatting Table Styles...

Search Catine Watson CW ON 2 12 385 3 _financial reise, werksheet (1)als. ome Insert Page Layout Formulas Data Review View Help Times New Roman - 11 AA EE BWrap Test BIUD A E Merge Alignment - Share...

Required: In the following table, using the drop-down lists provided, identify each of the company's expenses as (1) variable, fixed or mixed and (2) direct, indirect or both direct and indirect as...

Two other questions were asked in Exercise: Number of weeks job searching? Salary ($ thousands)? The placement office wants the following: a. Graphically describe salary. b. Is salary related to the...

The following information is available for LCole Inc. and Woodward Inc. at December 31, 2014: Required a. What is the accounts receivable turnover for each of the companies for 2014? b. What is the...

\ table [ [ Oty of Botton bonds,Falr Market Value ] , [ Soock in Brwn Corporation,$ 2 , 5 0 0 , 0 0 0

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...