Directions. Read and analyse the given data. Answer the questions below on a separatesheet of paper.The January 31. 202x Statement of Financial Position of Shelpat Corporation follows:Cash8,000Accounts receivable (net of allowance for uncollectibleAccounts of P2,000)38,00016,000InventoryProperty, plant and equipment (net of allowance forAccumulated depreciation of P60,000)40 000P. 102,000Total AssetsAdditional information:• Sales are budgeted as follows:FebruaryP110,000120 000March• Collections are expected to be 60% in the month of sale. 38% the nextmonth and 2 % uncollectible.• The gross margin is 25% of sales. Purchases each month are 75% of thenext month's projected sales. The purchases are paid in full the followingmonth.• Other expenses for each month, paid in cash, are expected to be P16,500.Depreciation each month is P5,000.1. What are the budgeted cash collections for February 202x?P101,800P104,000P63,800P66,000a.с.b.d.2. What is the pro-forma income (loss) before income taxes for February 202x?P(3,700)P(1,500)P3,800P6,000а.с.b.d.

Jan Financial information Cash 8,000 Account receivable 40,000…

Answered: 1. What are the budgeted cash…

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

ADAK STEEL budget info: 01 02 04 $2,500,000 $2,000,000 $2,200,000 $2,800,000 $500,000 $500,000 $600,000 $700,000 $800,000 $800,000 $900,000 $1,000,000 $400,000 $400,000 $400,000 $400,000 Sales on account Purchases of material on account Payroll Miscellaneous Cash collections of sales on account: 70% current Quarter; 20% following Q 4% - never Sales in previous year: 3rd Q-$1,800,000 4th Q-$2,400,000 Material Purchases: Paid ½ in current Q; ½ in next Q Purchases in 4th Q of previous year: $600,000 All other items (payroll, miscellaneous) are paid in current month. Non-operating cash outlays: Dividends: Bond interest: Bond Principal: 6% second following Q $90,000 every Q. $60,000 on June 30 and $40,000 on December 31. $1,000,000 on June 30. $120,000 Annual interest rate: 8% Beginning Cash Balance, Jan. 1: Minimum Balance: $100,000 REQUIRED: Prepare a Cash Budget Repay loan only when you have enough cash to pay entire loan. Pay interest when you pay principal. Borrow at beginning of Q,…
Items 23 through 25 are based on the following data: The January 31, 2020 balance sheet of Miko Corporation shows the following information: P8,000 Cash for 38,000 Accounts receivable (net of allowance uncollectible accounts of P2,000) 16,000 Inventory 40,000 Property, plant and equipment (net of allowance for accumulated depreciation of P60,000) P102,000 Total assets P82,500 Accounts payable Ordinary shares Retained earnings (deficit) Total liabilities and stockholder's equity 50,000 (30,500) P102,000 Additional information: Sales are budgeted as follows: February P110,000 March 120,000 Collections are expected to be 60% in the month of sale, 38% the next month, and 2% uncollectible. The gross margin is 25% sales. Purchases each month are 75% of the next month's projected sales. The purchases are paid in full the following month. o Other expenses for each month, paid in cash, are expected to be P16,500. Depreciation each month is P5,000.
135. The information below is taken from a government’s budget. Programmes = 75 Compensation = 55 Interest Payments = 25 Capital Expenditure = 35 Amortisation = 15 Income/Profits Taxes = 50 Value Added Taxes = 60 Import Duties = 45 User Fees = 15 How much is the primary balance? Select one: a. 45 b. −20 c. 25 d. −30 e. 5
M1
H13 A 5 6 January 7 February 8 March a A 33 13 fx Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and 3 interest payments) for the first three months of next year. (Click on the Graded Worksheet Tab below.) В Minimum cash balance 14 Monthly interest rate 15 January 1 cash balance C Cash Receipts Cash payments $525,000 $475,000 400,000 350,000 450,000 525,000 Kayak requires a minimum cash balance of $30,000 at each month-end. Loans taken to meet this requirement charge 1% interest per month, paid at each month-end. The 10 interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $30,000 is used to repay loans at month-end. The company has a cash balance of $30,000 and a loan balance of $60,000 at January 1. $30,000 1% $30,000 $60,000 D 16 January 1 loan balance. 17 18 Required: Prepare monthly cash budgets for January,…
DO THIS IN EXCEL ONLY AND SHOW THE FORMULAS. IF COMPLETE I WILL UPVOTE THANK YOU
How much external funds would Batik Company need? Negative EFN of ₱81,705 Positive EFN of ₱81,705 Negative EFN of ₱385,675 Positive EFN of ₱385,675
Goods sent on consignment R760 000. Opening consignment stock R48 000. Cash sales R700 000. Consignor’s expenses R20 000. Consignee’s expenses R12 000. Commission R20 000. Closing consignment stock R300 000. The profit on consignment is________. Select one: a. R150 000 b. R140 000 c. R92 000 d. R456 000
WhyRU Company usually depreciates its equipment using straight line method for accounting purposes, but for tax purposes its sum-of-the-years method. WhyRU Company acquired the equipment through purchase amounting to P2,400,000 on January 1,2018. Assume a tax rate of 30%. Useful life is 4 years. WhyRU Company made the following income in its income tax return available through reports for 2018 – P800,000; 2019 – P890,0000; 2020 – P1,200,000; 2021 – P1,500,000 There is no other differences between WhyRU's accounting income and taxable income for years 2018, 2019, 2020 and 2021 other than for the difference in depreciation for the equipment described.
8

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS

1. What are the budgeted cash collections for February 202x? P101,800 P63,800 P66,000 a. с. b. d. P104,000 2. What is the pro-forma income (loss) before income taxes for February 202x? P(3,700) P(1,500) P3,800 P6,000 а. C. b. d.