Question: #4 Problem - Budgeted Balance Sheet Using the data below, determine cash reported the budgeted balance sheet for 2017. Each correct answer is worth 1.5_point(s).

#4 Problem - Budgeted Balance Sheet Using the data below, determine

#4 Problem - Budgeted Balance Sheet Using the data below, determine "cash" reported the budgeted balance sheet for 2017. Each correct answer is worth 1.5_point(s). Cash balance on January 1, 2017 $20,000 Forecasted sales for 2017 $700,000 Portion of forecasted sales will be on credit 80% Portion of credit sales to be collected in 2017 70% Prior year accounts receivables expected to be collected in 2017 $12,000 One required principal payment due on December 31, 2017. $20,000 One required interest payment due on December 31, 2017 based upon the outstanding loan balance of $120,000 at the end of December 31, 2017. Interest rate on loan is 10%. Cash Budget Accounts receivable collected 1. Cash Sales 2. Credit Sales 3. Loan payment 4. Interest payment 5. 6. Net increase in cash Add: beginning cash balance Ending cash balance 20,000 7

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 Accounting Questions!

using the data below determine "cash" reported the budgeted balance sheet for 2017 $20,000 Cash balance on January 1, 2017 $700,000 Forecasted sales for 2017 80% Portion of forecasted sales will be...

Please include excel formulas 15 HX for D E F G H 1 K L M B B 1 Problem 5: Purchase budget and Cash payment schedule 2 Woodwards Inc. is preparing its inventory purchase budget for the second quarter...

Please answer the following questions below. Ida Company produces a handcrafted musical instrument called a gamelan that is similar to a xylophone. The gamelans are sold for $920. Selected data for...

I finished most of the problem I just need help with requirement 4, A budgeted balance sheet as of June 30. You have just been hired as a new management trainee by Earrings Unlimited, a distributor...

I would like to have the answers for question 1 thru 64 please ACCA 310 FALL 2015 ASSIGNMENT QUIZ CHAPTERS 7 TO 10 Multiple Choice: 1. The financial budget includes a. only the capital budget and the...

I would like have the answers for questions 65 - 130 ACCA 310 FALL 2015 ASSIGNMENT QUIZ CHAPTERS 7 TO 10 Multiple Choice: 1. The financial budget includes a. only the capital budget and the cash...

need help with preparing budget on excel and cant put direct answers so please explain how to get each answer. Will rate positively ! Required: Prepare a master budget for the three-month period...

Our controller, Veronica Verrengia, is negotiating with our bamboo suppliers in China. We need the Softball Bat Divisions Master Budget for 2018 for our corporate strategic planning process, and we...

Bowman Corporation has just received an invoice. The terms are 2/10, net 30. The total amount of the invoice is $3,000. What is the interest rate for the 20 day period? 1.5698% 1.8848% 1.8905%...

Trevi Corporation recently reported an EBITDA of $32,800 and $9,700 of net income. The company has $6,600 interest expense, and the corporate tax rate is 35 percent. What was the companys...

Hedge funds charge expense fees and performance fees. The average performance fee on hedge funds is _ _ _ _ _ _ _ _ _ _ blank. Multiple Choice 1 5 percent 1 0 percent 2 5 percent 2 0 percent 5 percent

last two options for the multiple choice are : performance management development A construction equipment manufacturer, Roswell Corporation, is focusing on becoming a leader in sustainability in...

The small company for which you work manufactures and sells camping equipment. Recently, the companys management team decided to expand its sales efforts to include e-commerce. Barbara Kramer, the...

Youre interested in learning what type of backpack is most popular among students on your campus. (Objectives 2, 3, and 6) a. Outline your data-gathering plan and share it with the class. b. Using...

Teamwork. Form teams of no more than five people. Each team will select an important current issue or problem on the campus. As directed by your instructor, do one or more of the following...