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 solution
Students have asked these similar questions
Assume 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…
Complete your calculations by filling in the highlighted cells. Discuss your observations about the way cash is collected if the company needs $150,000 per month for expenses.
Assume 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.
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
- The sum of all of your customer Accounts Receivable is listed as part of on your balance sheet. * O Current Assets Current Liabilities Long-term Assets Suppose you are closing the books at the end of a fiscal year and you have a balance of $75000 in your Revenue account. What should you do with the balance? * O You should do nothing, and carry it over to the next accounting year. You should zero it out. You should move it to the liability account.arrow_forwardUse the following scenario to fill out the Monthly Cash Flow Statement Worksheet. Use a separate paper for your answer. You pay payment You pay for Your monthly renter's insurance of $20 Your monthly comes in and you must pay $75 a $150 car You receive your monthly You pay rent of $450 per You pay your medical insurance of $75 a month for monthly Your monthly utilities are due. You owe $125 gross salary of $2,000 You month car You groceries of $200 taxes come out of your you go to a movie a friend $50 paycheck Federal Tax $150 State tax $50 Social security $200 You go out to have dinner You find the perfect outfit with friends. Your bill is $25 pay insurance of $150 It's your mother's birthday. purchase your pay You that cost $10 present You put $100 vacation at You hit a pothole and the beach have a flat.tire. You must pay $75 for a new one for your date weekend You pay one $100 for the outfit Income Gross Salary Total Income Expenditures Fixed Expenses Rent Renter's Insurance…arrow_forwardDraw 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?arrow_forward
- Person A deposits $2750 in an account that pays 5% interest compounded once a year. Person B deposits $2200 in an account that pays 6% interest compounded monthly. Complete parts (a) through (c) below. a. Who will have more money in their account after one year? How much more? Select the correct choice below and fill in the answer box within your choice. (Round to the nearest dollar as needed.) O A. Person A will have $ 552 more than Person B. O B. Person B will have $ more than Person A. b. Who will have more money in their account after five years? How much more? Select the correct choice below and fill in the answer box within your choice. (Round to the nearest dollar as needed.) O A. Person B will have $ more than Person A. O B. Person A will have $ more than Person B.arrow_forwardFor TVM calculator: Write each known variable’s value as it appears in the calculator and use a question mark for the missing variable. Then, in the space provided write the missing variable’s value, as it appears in the calculator. Finally, write your final answer in context, with units, as a complete sentence. Patricia deposits $1,000 into an account that earns 4.9% compounded monthly and plans to make monthly payments of $170 into the account. How long must she invest until she has $35,000? N=? I= 4.9 PV=1,000 PMT=170 FV= 35,000 P/Y=12 C/Y=12 Missing Variable Value __________________ Context Sentence:arrow_forwardPerson A deposits $2750 in an account that pays 5% interest compounded once a year. Person B deposits $2200 in an account that pays 6% interest compounded monthly. Complete parts (a) through (c) below. a. Who will have more money in their account after one year? How much more? Select the correct choice below and fill in the answer box within your choice. (Round to the nearest dollar as needed.) O A. Person A will have $ more than Person B. B. Person B will have $ more than Person A.arrow_forward
- A person saves $100 in a bank account at the beginning of each month. The bank offers a return of 12% compounded monthly. a. Determine the total amount saved after 12 months. b. After how many months does the amount saved exceed $2000? 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_forwardSuppose that with the advent of ATMs, a person withdraws money once every two days. Further, suppose this person spends $10 per day. Calculate the amount of money this person withdraws each time she goes to the bank.arrow_forwardYou invest $ 500 today and receive $ 750 at the end of 5 years. a. DETERMINE the internal rate of return, using hand interpolation. Write answer to 2 decimal places. b. SUBMIT the procedures via the spreadsheet icon. Show all your computations. -arrow_forward
- Assume that your team is in business and you must borrow $6,000 cash for short-term needs. You have been shopping banks for a loan, and you have the following two options. A. Sign a $6,000, 90-day, 10% interest-bearing note dated June 1. B. Sign a $6,000, 120-day, 8% interest-bearing note dated June 1. Required 1. Discuss these two options and determine the better choice. Ensure that all teammates concur with the decision and understand the rationale. 2. Each member of the team is to prepare one of the following journal entries. a. Option A—at date of issuance. b. Option B—at date of issuance. c. Option A—at maturity date. d. Option B—at maturity date. 3. In rotation, each member is to explain to the team the entry he or she prepared in part 2. Ensure that all team members concur with and understand the entries. 4. Assume that the funds are borrowed on December 1 (instead of June 1) and your business operates on a calendar-year reporting period. Each member of the team is to prepare…arrow_forwardSolve the following problems without using any software, do everything in digital format, explain the formulas, substitutions and result 4. A person today deposits in a bank account the sum of $ 125,000 with a monthly interest rate of 0.75% (9% per year) and plans to withdraw $ 4,000 from the account at the end of each month until the account is zero. For how many months will you be able to make these withdrawals?arrow_forwardGrandpa puts $50,000 into a bank account for you earning 3% compounded monthly. How much will you have in the account after 5 years if you don't make Grandpa mad enough to take the money back before then? Select an answer and submit. For keybard navigation, use the up/down arrow keys to select an answer. a b $57,963.70 $58,659.93 C $58,080.841 d $62,567.12arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Individual Income TaxesAccountingISBN:9780357109731Author:HoffmanPublisher:CENGAGE LEARNING - CONSIGNMENT
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Individual Income Taxes
Accounting
ISBN:9780357109731
Author:Hoffman
Publisher:CENGAGE LEARNING - CONSIGNMENT