Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 1, Problem 7R
To determine
Provide a chart that explains whether withdrawal amount that decreases the cash percentage to 50%.
To determine
Complete the transactions on the worksheet and save under the head PTRANST.
To determine
Provide a 3-D pie chart that shows the relative percentages of the balance of the liability and equity accounts.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Draw cashflow and box the final answer
A man deposited in his bank account an amount of P550,000.He has an annual allowance expense of P9500 and bookcosts of P3000 every 3 years. He was an irregular atengineering and at the end of year 6, the he broke anequipment in the laboratory and was repaired at a rebuild costof 22,000. How much will be left at his account at year 9, at ifmoney rate is 8% compounded annually?
Answer and draw neatly the necessary cash flow diagrams, and box your final answers.
A man purchases a lot worth 1,000,000 if paid in cash. On installment basis, he paid P200,000 down payment, P300,000 at the end of the year, P400,000 at the end of the fourth year and the last payment at the end of the 5th year. If money is worth 16%, what is the worth of the last payment?
Suppose that you borrow a loan of amount P from a bank at the end of month 3 and make the monthly deposits to the bank as in the cash flow diagram below. In the following cash flow diagram A7=A8=A9=1000, and starting with A10, deposits start decreasing in the amount of 40. However, due to a cash problem, you miss a payment at month 12 but continue with your original payment plan thereafter (that is, A10=960, A11=920, A12=0, A13=840 etc). With these payments, your dept to the bank will be 0 at the end of month 20. Assuming that the interest rate is 12% compounded monthly.
1-Find out the initial loan amount P.
2-Find the total interest paid to the bank
Chapter 1 Solutions
Excel Applications for Accounting Principles
Ch. 1 - On June 1 of the current year, Wilson Wood opened...Ch. 1 - On June 1 of the current year, Wilson Wood opened...Ch. 1 - On June 1 of the current year, Wilson Wood opened...Ch. 1 - On June 1 of the current year, Wilson Wood opened...Ch. 1 - On June 1 of the current year, Wilson Wood opened...Ch. 1 - On June 1 of the current year, Wilson Wood opened...Ch. 1 - Prob. 7R
Knowledge Booster
Similar questions
- Refer to the present value table information on the previous page. What amount should Brett have in his bank account today, before withdrawal, if he needs 2,000 each year for 4 years, with the first withdrawal to be made today and each subsequent withdrawal at 1-year intervals? (Brett is to have exactly a zero balance in his bank account after the fourth withdrawal.) a. 2,000 + (2,000 0.926) + (2,000 0. 857) + (2,000 0.794) b. 2,0000.7354 c. (2,000 0.926) + (2,000 0.857) + (2,000 0.794) + (2,000 0.735) d. 2,0000.9264arrow_forwardMelannie Bayless has purchased a business building for $331,000. She expects to receive the following cash flows over a 10-year period: Year 1: $43,000 Year 2: $58,500 Year 3-10: $89,000 What is the payback period for Melannie? Round your answer to one decimal place.fill in the blank What is the accounting rate of return? Enter your answer as a whole percentage value (for example, 16% should be entered as "16" in the answer box).fill in the blankarrow_forwardengr. secula started 2000.00 each year for 25 years until his retirement at 65 years old. a year after he retired he withdraw 10000.00 for period of 5 years. in the ninth and tenth years he decided to only withdraw 5000.00 per year. in the twelfth year, he withdraw the remaining money in his account. if the interest rate year was 9% per year. a.) draw the cash flow diagram with functional symbols. b) what was the final withdraw from his account?arrow_forward
- Bulldogs Inc. maintains a cash buffer for unexpected cash outlays for the year amounting to 3,000. Bank of Wildcats charges Bulldogs P15 for every transaction with the bank. The bank grants 5% annual interest. Bulldogs is contemplation if it will still need to have the cash buffer. How much is the annual savings in annual holding cost of cash for Bulldogs if it will not have a cash buffer?arrow_forwardAssume that you are nearing graduation and have applied for a job with a local bank. As part of the bank's evaluation process, you have been asked to take an examination that covers several financial analysis techniques. The first section of the test addresses time value of money analysis. See how you would do by answering the following questions. Draw time lines for (a) a $2000 lump sum cash flow at the end of year 4, (b) an ordinary annuity of $1000 per year for 5 years, and (c) an uneven cash flow stream of -$450, $1000, $650, $850 and $500 at the end of years 0 through 4. What is the future value of an initial $1000 after 5 years if it is invested in an account paying 5% annual interest? What is the present value of $1000 to be received in 4 years if the appropriate interest rate is 5%? We sometimes need to find out how long it will take a sum of money (or anything else) to grow to some specified amount. For example, if a company's sales for 2020 is $1000 and expected to grow…arrow_forwardZappy Inc. designs a new financial instrument that called the SafetyNet. This instrument gives the holder access to the following cashflows: For the first 4 years, the holder receives $95 per year starting one year from today (a total of 4 payments). The holder does not receive any cashflows for year 5. Starting at the end of year 6, the holder receives $60 growing at a rate of 4% per year forever. The holder has to pay a “service fee” of $7 every year starting at the end of year 2; this goes on forever. The prevailing discount rate throughout is 6%. The financial engineer would like to determine a fair market price for this financial instrument. What do you suggest this price to be? Please show your work.arrow_forward
- A financial engineer designs a new financial instrument that she calls the SafetyNet. This instrument gives the holder access to the following cashflows: • For the first 4 years, the holder receives $95 per year starting one year from today (a total of 4 payments). • The holder does not receive any cashflows for year 5. • Starting at the end of year 6, the holder receives $60 growing at a rate of 4% per year forever. • The holder has to pay a “service fee” of $7 every year starting at the end of year 2; this goes on forever. The prevailing discount rate throughout is 6%. The financial engineer would like to determine a fair market price for this financial instrument. What do you suggest this price to be? Please show your work.arrow_forwardOn the first day of the year, a man deposits ₱1,000 in a bank at 8% per year compounded annually. He withdraws ₱80 at the end of the first year, ₱90 at the end of the second year, and the remaining balance at the end of the third year. a. How much does he withdraw at the end of the third year? b. What is the net cash flow? c.How much better off, in terms of net cash flow, would he have been if he had not made the withdrawals at the ends of years one and two?arrow_forwardTerry has invested $20 000 into a fund with interest at j12 = 18% p.a. What level payment can be withdrawn from the fund at the beginning of each half-year in perpetuity? Answer this question by, first, drawing a cash flow diagram, then writing down the equation of value, and then solving it. Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.arrow_forward
- Please do not use excel Your uncle has $280,000 invested at 7.5%, and he now wants to retire. He wants to withdraw $35,000 at the end of each year, starting at the end of this year. He also wants to have $25,000 left to give you when he ceases to withdraw funds from the account. For how many years can he make the $35,000 withdrawals and still have $25,000 left in the end?arrow_forwardYour uncle has $298,000 invested at 7.7%, and he now wants to retire. He wants to withdraw $35,000 at the end of each year, beginning at the end of this year. He also wants to have $25,000 left to give you when he ceases to withdraw funds from the account. What is the maximum number of $35,000 withdrawals that he can make and still have at least $25,000 left in the account? (Hint: If your solution for N is not an integer, round down to the nearest whole number.) Group of answer choices 12 11 13 15 16arrow_forwardInc. maintains a cash buffer for unexpected cash outlays for the year amounting to 3,000. Bank of Wildcats charges Inc P15 for every transaction with the bank. The bank grants 5% annual interest. Inc is contemplation if it will still need to have the cash buffer. How much is the annual savings in annual holding cost of cash for Inc if it will not have a cash buffer?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningIntermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning