Your mother plans to join the employee's cooperative. She wants to know how much her money would earn in six months. The cooperative requires a monthly contribution of Php1,000 starting June 2020, with a compound interest rate of 3%. How much will your mother's money be by December 2020? Prepare a report showing a cash flow diagram. At the end of your report, write a conclusion stating your opinion to help your mom to decide.

Your mother plans to join the employee's cooperative. She wants to know how much her money would earn in six months. The cooperative requires a monthly contribution of Php1,000 starting June 2020, with a compound interest rate of 3%. How much will your mother's money be by December 2020? Prepare a report showing a cash flow diagram. At the end of your report, write a conclusion stating your opinion to help your mom to decide.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

ChapterMB: Model-building Problems

Section: Chapter Questions

Problem 27M

See similar textbooks

Similar questions

She wants to know the amount of money she will be receiving after 6 months What I Can Do Read and analyze the situation below then answers the question gve. Your mom asked your opinion if she will be joining the cooperative in her office. and wanted to buy something in December. The cooperative wants her to contribute P1,000 per month beginning in June 2020 which will earn 3% compounded monthly. How much will be the future value of your mom's contribution at the end of December 2020? Tasks: Tou need to prepare a report showing a cash flow diagram on the total amount Of money your mother will earn at the end of December. Teport, write a conclusion stating your opinion to help your mom to decide. At the end of your Cash Flow Diagram onclusion:
Suppose that your colleague has approached you with an opportunity to lend $25,000 to her laundry business in Accra. The business, called Do it yourself launderette, plans to offer home services to customers at area. Funds would be used to lease a delivery vehicle, purchase supplies, and provide working capital. Terms of the proposal are that you would receive $5,000 at the end of each year in interest with the full $25,000 to be repaid at the end of a ten year period Assuming a 10% required rate of return, calculate the present value of cash flows and the net present value of the proposed investment Based on this same interest rate assumption, calculate the cumulative cash flow of the proposed investment for each period in both nominal and present value terms?
Suppose you borrow money from your parents for college tuition on January 1, 2019. Your parents require four annual payments of $30,000 each, with the first payment due on January 1, 2023. They are charging you 5% annual interest. What is the cost of college tuition? (Use spreadsheet software or a financial calculator to calculate your answer. Round intermediary calculations to two decimal places and round your final answer to the nearest dollar.) Question content area bottom Part 1 A$91,894 B.$111,697 C.$120,000 D.$88,475
Suppose that your colleague has approached you with an opportunity to lend $25,000 to her laundry business in Accra. The business, called Do it yourself launderette, plans to offer home services to customers at area. Funds would be used to lease a delivery vehicle, purchase supplies, and provide working capital. Terms of the proposal are that you would receive $5,000 at the end of each year in interest with the full $25,000 to be repaid at the end of a ten[1]year period. a) Assuming a 10% required rate of return, calculate the present value of cash flows and the net present value of the proposed investment. b) Based on this same interest rate assumption, calculate the cumulative cash flow of the proposed investment for each period in both nominal and present[1]value terms. c) If we are to use the monetary approach to exchange rate determination, what will be the predicted effect on the exchange rate of domestic currency if domestic real income increases? d) Using the same…
An is considering to take out a loan of $10,000 to fund this promotion service. Option 1: Ella needs to make daily payment of $67.2 from 1 January 2024 to 31 May 2024 (inclusive). (Assume that there are 365 days in a year.). Find the implied effective annual rate charged by the bank? use excel Which one is better?
Suppose your first job pays you Php 300,000 annually. Answer the following questions assuming (a) you are unmarried, and (b) you are married with two young children. Let see how your allocation change. What percentage should your cash reserve contain?
Anjelina wants to purchase an annuity that will pay her the $2,000 she needs at the end of every six months to support her shoe collection. If she plans to do this for the next 4 years and if money is currently worth 3.2% compounded semi-annually, what would her initial investment have to be? Refer to the "?"s in the table and considering inflows and outflows of cash, enter the appropriate values in the blanks below. Round dollar answers to 2 decimal places. Mode ? Mode = N = PV = PMT= FV= Previous Page N ? I/Y 3.2 A N A Next Page P CY 2 PV ? PMT ? PY 2 FV ?
Suppose your first job pays you Php 300,000 annually. Answer the following questions assuming (a) you are unmarried, and (b) you are married with two young children. Let see how your allocation change. 1. What percentage should your cash reserve contain? 2. What are the insurances you will carry and how much? 3. What are the other allotments do you plan to carry?
A parent on the day the child is born wishes to determine what lump sum would have to be paid into an account annually, in order to withdraw Php 20,000 each on the child’s 18th, 19th, 20th and 21st birthdays. Use 4% Show complete solution.
You are a financial adviser working with a client who wants to retire in eight years. The client has a savings account with a local bank that pays 9% annual interest. Tne client warts to deposit an amount that will provide her with $1,000,000 when she retires. Currently, she has $300,000 in the account. EV of $1, PVof $1, FVA of $1, and PVA of $1) (Use the appropriate factor(s) from the tables provided.) How much additional money should she deposit now to provide her with $1,000,000 when she retires? (Round your answer to nearest whole dollar.) Additional deposit amount
Mrs. Collins wants to start a clothing business. He plans to invest Gh₵ 30,000 of his savings into the new business. She thinks that some additional finance will be required in the short term and plans to approach his bank for this. Mrs. Collins asks for your assistance in producing a cash budget for his new business for the next six months (i.e., January – June, 2021). She provides the following information: The business, which is to be called ‘Pink Lady Clothing’ will commence in January 2021.Non-current assets costing Gh₵ 10,000 will be bought in early January. These will be paid for immediately and are expected to have a five-year life, at the end of which they will be worthless.An initial stock (inventory) of goods costing Gh₵ 6,000 will be bought and paid for at the beginning of January.Mrs. Collins is estimating that the goods she expects to sell in January will be replaced by purchases made in January, and so on. The following are monthly sales forecast: January February March…
A couple wants to begin saving money for their daughter's education. $16,000 will be needed on the child’s 18th birthday, $18,000 on the 19th birthday, $20,000 on the 20th birthday, and $22,000 on the 21st birthday. Assume 5% interest with annual compounding. The couple is considering two methods of accumulating the money. a. How much money would have to be deposited into the account on the child's first birthday to accumulate enough money to cover the education expenses? (Note: A child’s “first birthday” is celebrated 1 year after the child is born.) b. What uniform annual amount would the couple have to deposit each year on the child’s first through seventeenth birthdays to accumulate enough money to cover the education expenses?