Mr.Rudi is a manager in an automation company. As part of his future planning, Mr.Rudi plans to manage an investment of IDR 100 thousand in the first year and increase this amount by 10% every year. For this calculation, you have to create an excel spreadsheet based on the data provided along with the Cash flow diagram. Based on the data provided: a. How long will Mr.Rudi's account have a future monetary value of IDR 3,000,000 at a rate of return of 6% per annum? b. If Mr.Rudi calculates to the next 30 years, determine the total nominal amount in the next 10, 20, and 30 years that will be achieved by Mr.Rudi. The calculation spreadsheet should describe the amount deposited each year.

Mr.Rudi is a manager in an automation company. As part of his future planning, Mr.Rudi plans to manage an investment of IDR 100 thousand in the first year and increase this amount by 10% every year. For this calculation, you have to create an excel spreadsheet based on the data provided along with the Cash flow diagram. Based on the data provided: a. How long will Mr.Rudi's account have a future monetary value of IDR 3,000,000 at a rate of return of 6% per annum? b. If Mr.Rudi calculates to the next 30 years, determine the total nominal amount in the next 10, 20, and 30 years that will be achieved by Mr.Rudi. The calculation spreadsheet should describe the amount deposited each year.

ENGR.ECONOMIC ANALYSIS

14th Edition

ISBN:9780190931919

Author:NEWNAN

Publisher:NEWNAN

Chapter1: Making Economics Decisions

Section: Chapter Questions

Problem 1QTC

See similar textbooks

Similar questions

4:09 Assignment 2-2022.pdf 4. Construct a cash flow diagram to find the present worth in year 0 at an interest rate of 12% per year for the following situation. Year Cash Flow, $ 0 5. Construct a cash flow diagram that represents the amount of money that will be accumulated in 20 years from an investment of $30,000 now at an interest rate of 10% per year. 6. for the cash flow diagram shown, what are the present and the future worth in year 4? i = 7%/semiannual period 1 2 470 3 420 2 4 370 0 1-5 5 320 6 3 270 7 Y 220 4 -15,000 +8,500 8 200 :!!! 5G Years Semiannual periods 7. Construct the cash flow diagram for A mechanical device will cost $20,000 when purchased. Maintenance will cost $1000 per year. The device will generate revenues of $5000 per year for 5 years. The salvage value is $7000. 8. Each year Exxon-Mobil expends large amounts of funds for mechanical safety features throughout its worldwide operations. Carla Ramos, a lead engineer for Mexico and Central American operations,…
A person buys a piece of lot for Php 136181 down payment and 10 deferred semi-annual payments of P 5,000 each, starting 6 years from now. What is the present value of the investment if the rate of interest is 13% per year compounded quarterly?Round off the interest rate to five decimal places.Round your answer to 2 decimal places.Note: show the cash flow diagram and write complete solution in a paper
Suppose that a father, on the day his son is born, wishes to determine what lump amount would have to be paid into an account bearing interest of 17% per year to provide withdrawals of $4,000 on each of the son's 9th, 10th, 11th, and 12th birthdays. How much money does the father have to deposit on the day his son is born ? Please, represent the cash-flow diagram.
A firm has borrowed $5,000,000 for 5 years at 10% per year compound interest. The firm will make no payments until the loan is due, when it will pay off the interest and principal in one lump sum. What is the total payment? Assume that your answer is in units of $. Only input the numeric value of your calculation.
1.) Calculate the compound interest for a Php 100,000 investment under the following conditions: Interest rate: 5% , Investment Period: 5 years, Compounding: Monthly 2.) Mr. Robles got a $1500.00 loan for 2 years. He paid $80 in interest. What was the interest rate?
A person buys a piece of lot for Php 107203 down payment and 10 deferred semi-annual payments of P 5,000 each, starting 4 years from now. What is the present value of the investment if the rate of interest is 13% per year compounded quarterly? Note: Round off your interest rate to five decimal places. Round your answer to 2 decimal places.Create also a cashflow diagram
You invest $10,000 in a fund that pays 7% per year for 5 years. How much is in the fund at the end of 5 years if (forgetting leap years and making “convenient” assumptions): a. Compounding is annual? b. Compounding is quarterly? c. Compounding is monthly? d. Compounding is daily?
UPVOTE WILL BE GIVEN. PLEASE WRITE THE COMPLETE SOLUTIONS AND DRAW THE CASH FLOW DIAGRAM. NO LONG EXPLANATION NEEDED. FOLLOW THE INSTRUCTIONS CAREFULLY. A recent government study reported that a college degree is worth an extra $35947 per quarter income compare to high school graduate. If the interest is 6% per year compounded quarterly and you work for 31 years, what is the future compound amount of this extra income? Answer to 2 decimal places.
In the accompanying diagram, Figure what is the value of K on the left-hand cash-flow diagram that is equivalent to the right-hand cash-flow diagram?Let i = 12% per year.
UPVOTE WILL BE GIVEN. PLEASE WRITE THE COMPLETE SOLUTIONS AND DRAW THE CASH FLOW DIAGRAM. NO LONG EXPLANATION NEEDED. FOLLOW THE INSTRUCTIONS CAREFULLY. Calculate the future equivalent at the end of 2017, at 8% per year, of the following series of cash flows: [Use a uniform gradient amount (G) in your solution.]
Eleanor makes a year-end deposits of Php. 500 the first year, Php. 550 the second year, Php. 605 the third year, and so on, increasing the next year’s deposit by 10% of the deposit in the preceding year until the end of the tenth year. Ronald makes equal year-end deposits of Php. 700 each year for 10 years. If interest on both funds is 12% compounded annually, who will be able to save more at the end of the 10 years?
Q) A civil engineer planning for her retirement places 11% of her salary each year into a high-technology stock fund. If her salary this year (end of year 1) is $200,000 and she expects her salary to increase by 4% each year, what will be th future worth of her retirement fund after 14 years provided it earns 8% per year? Solve it correctly. Typed or handwriting with concept use. Not solve in excel works.