Prepare the cash budget for January and February of Gilmore Company using the following data: January February Cash Receipts Cash Disbursements Beginning Cash Balance Required Ending (Minimum) P12,000 P46,500 P42,100 P38,320 P37,220 P5,210 As per computation P12,000 Cash Balance
Q: The future value of $3000 deposited a year of 4 years earning 6 percent would be
A: The question is related to Time Value of money. Future Value is the value at some future time of a…
Q: 5. What is the Capitalized Worth, when i= 10% per year, of $3000 per year, startıng in one yea…
A: Capitalized cost of a project can be defined as the present value of all costs that will be incurred…
Q: Suppose the required reserve ratio is 14.25%. The simple money multiplier will be approximately…
A: The simple money (deposit) multiplier gives the change in money supply due to one unit change in the…
Q: A tractor was purchased for $74486 and at the bank interest rate of 4.67% per year. The residual…
A: Future Value: The future value is the amount that will be received at the end of a certain period.…
Q: ABC Co. bought 1,000 CALL options of XYZ Corporation with a strike price of ₱52 at ₱2.75 per option.…
A: Exercise of option - Call option is a right to buy the stock at the strike price on expiry date, if…
Q: You want to buy a car, and a local bank will lend you $20,000. The loan would be fully amortized…
A: A loan is an agreement where an amount is forwarded in exchange for periodic payments that cover the…
Q: 1) The finance manager is required to look into the financial implications of every decision in the…
A: True. The financial manager has to look into every decision that has financial consequences. He/she…
Q: A fixed capital investment of P10,000,000 is required for a proposed manufacturing plant and an…
A: Fixed capital (F) = P 10,000,000 Working capital (W) = P 2,000,000 Depreciation (D) = 10% of F = P…
Q: The management of ProdPharm.inc has decided to increase the production capacity of its factory by…
A: The real interest rate is the actual rate that an investment earns taking into account the frequency…
Q: Consider the following cash flows. The interest rate is 8%. What is the duration (hint: you need…
A: Interest rate = 0.08 Cash flow duration is the weighted-average time to maturity of the cash…
Q: You are preparing to produce some goods for sale You will sell them in one year and you will incur…
A: For calculation of sell price we will use time value of money concept where future value of the…
Q: The following data are gathered: · The real risk-free rate is 1.05% · Inflation premium…
A: Risk free rate of the return, which is defined as the theoretical return rate of investment along…
Q: If the municipal bond rate is 6% and the corporate bond rate is 7%, what is the marginal tax rate,…
A: Bonds: Bonds are the liabilities of the company which is issued to raise the funds required to…
Q: What is the present value of 5,275 due in 6 months if 11% interest is paid
A: Future Value = (P * R * T) + PWhere P = Present ValueR = Rate of InterestT = Time Period
Q: Explain the Currency crisis, Banking Crisis and Foreign Debt Crisis
A: In the world of finance, we often see or hear about one crisis or the other. The 2008 financial was…
Q: You decide to invest P35,000 in RX Pharmaceuticals, P35,000 in TS Banks, and P10,000 in each of the…
A: The expected return of Portfolio is calculated by multiple the expected return of each security with…
Q: Kiambu County Government has received equipment worth Kshs.461,520,000 from an American Company…
A: Foreign exchange risk It is the losses that a international monetary exchange might bring about…
Q: Suppose the spot exchange rate for the Hungarian Forint is HUF 209/USD. The infiation rate in the US…
A: The following information has been provided in the question: Spot exchange rate for Hungarian…
Q: .A bank offers a 272- day discounted loan at a simple discount rate of 12%. (a) How much money would…
A: The discount on loan is given and that discount on loan is the interest being charged on the loan…
Q: corporate issue will be brought to the market at a spread of T+ 68bp. Explain what this means and…
A: Corporate bonds are issued with some benchmark interest rate and some addition to some benchmark…
Q: ABC has a return of 400,000 which is 2% more than its required return. If the cost of capital is…
A: Shareholder Equity: It can be described as the residual claim of the owners of the company after…
Q: Calculate the nominal and real return as well as the nominal and real risk premiums for the…
A: Real rate of return is the net return to the investor after adjustment of inflation. Return on…
Q: Co. has a debt to equity ratio of 25% and a weighted average cost of capital at 25%. The firm used…
A: Debt to equity ratio = 0.25 Therefore; Debt = 0.25 Equity = 1 Total capital = 1.25 (i.e. 0.25 + 1)…
Q: Kindly use PMT in your computations
A: Loan amount “PV” = 60000 Origination fees = 3%*60000 = 1800 Net loan amount = 60000-1800=58200 Time…
Q: National Co. has established a target capital structure of 30% debt and 70% common equity. The…
A: Last dividend (D0) = P2 Growth rate (g) = 0.02 Current market price (P0) = P25 Marginal cost of…
Q: If the manager of a gold mine wants to protect its operations against a market price decline, while…
A: It is a financial instrument whose value/price is determined by the given assets. Options, forwards,…
Q: Suppose that you have a plan to pay RO 0592 as an annuity at the end of n month for 20 years in the…
A: Hi There, Thanks for posting the questions. As per our Q&A guidelines, must be answered only one…
Q: Setrakian Industries needs to raise $99.4 million to fund a new project. The company will sell bonds…
A: Bond Price is Sum of all cashflows during the life of the bond discounted at Yield to maturity Bond…
Q: 3) What three things are required to make revenue management work AND why?
A: Revenue management is referred as the disciplined analytics application, which helps in prediction…
Q: The price of $6100 face value commercial paper is $5900. If the annualized investment rate is 10%,…
A: Here, Face Value of Commercial Paper is $6,100 Price of Commercial Paper is $5,900 Annualized…
Q: Which of the following rebalancing methodologies will ha market impact cost? Buy and Hold Momentum…
A: Rebalancing a portfolio It is a process by which the weights of the assets of a portfolio are…
Q: According to the CAPM, the expected return of an asset that has just diversifiable risk and no…
A: As per CAPM, Expected Return = Rf + ( Beta * (Rm -Rf)) Rf = Risk free rate of return Rm = Market…
Q: ABC Inc expects to have EPS (earning per share) of $5 in the coming year. The firms plan to pay all…
A: The Current Price per Share will be calculated by Gorden's Model. The current price per share is…
Q: Identify the type of merger in the following case: ABC manufactures furniture. It acquired a…
A: Merger means acquistion of one business by another. There are two parties involved in merger…
Q: duration __________ when maturity decreases. duration decreases when the coupon rate __________.…
A: The answer is option D. decreases/ increases/ increases duration decreases when maturity decreases…
Q: Assume your goal in life is to retire with one million dollars. How much would you need to save at…
A: To calculate the annual saving amount we will use future value of annuity formula as follows…
Q: uity X and Y provide the following payments: End of Year Y 1-10 1 K 11-20 2 21-30 1 K Annuity X and…
A: Annuity is a stream of constant regular payments.
Q: The following data are gathered: · The real risk-free rate is 1.05% · Inflation premium…
A: Treasury Bills: T-bills are the treasury bills issued by the government. These bills are risk-free…
Q: National Co.’s stock sells for P35 that recently paid a P5 dividend. The growth rate will remain the…
A: To calculate the cost of newly issued equity we will use the following formula as follows: Cost of…
Q: The rationales of Corporate Parents. Explain styles of Parenting – where do they potentially add or…
A: A corporate parent is a label given to an organization or someone with unique obligations for the…
Q: Assume that the expectations theory holds. What does the market expect will be the yield on 2-year…
A: Data given: Maturity Yield 2 5.40% 3 5.60% 5 6.00% Required: Yield on 2-year Treasury…
Q: If the interest rate on comparable debt is 2.0% is your broker fairly pricing the bond? (What is the…
A: Bond: It is a debt instrument issued by the firm (issuer) to raise debt capital. The issuer pays…
Q: A P1,000 bond which mature in 10 years and with a bond rate of 5% payable annually is to be redeemed…
A: The yield on the bond will reflect the rate of return at which the PV of all future cash flows is…
Q: You are the financial manager of the firm LAB.inc which does research in the medical field, your…
A: Given, The yearly payments $100,000
Q: What is the total return of an equal-weighted index over the holding period given the following data…
A: Return refers to the additional earnings over the invested amount. Basically, it is a profit which…
Q: 3) When firms increase their debt-equity ratio, we find: Group of answer choices The ROE always…
A: We know that debt is the cheaper source of finance, if any company uses more debts in capital…
Q: Identify which anti-hostile takeover strategies are being described. [S1] A merger will only push…
A: When a prospective merger or acquisition needs to be thwarted then there are several anti-hostile…
Q: A two-year project has sales of $582,960, cash costs of $411,015, and depreciation expense of…
A: Depreciation expense = $68,109 Tax rate = 0.24 Depreciation tax shield is also known as saving of…
Q: Which combination of investment policy and financing policy related to working capital provides the…
A: A relaxed current asset investment policy is one under which relatively large amounts of current…
Q: You just won the NY State Lottery. The Grand Prize is $275 million. Lottery officials give you a…
A: Present value of annuities to be received in future would give the value of money today can be…
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
- A companys controller is adjusting next years budget to reflect the impact of an expected 3 percent inflation rate. Listed below are selected items from next years budget before the adjustment. After adjusting for the 3 percent inflation rate, what is the companys total budget for the selected items before taxes for next year? a. 858,150 b. 860,412 c. 810,971 d. 858,971Relevant data from the Poster Companys operating budgets are: Additional data: Capital assets were sold in January for $10,000 and $4,500 in May. Dividends of $4,500 were paid in February. The beginning cash balance was $60,359 and a required minimum cash balance is $59,000. Use this information to prepare a cash budget for the first two quarters of the yearRelevant data from the operating budget of The Framers are: Other data: Capital assets were sold in quarter 1 and $8,000 was collected in quarter 1 and $500 collected in quarter 2. Dividends of $500 will be paid in May The beginning cash balance was $50,000 and a required minimum cash balance is $10,000. Prepare a cash budget for the first two quarters of the year.
- Roman Inc. has the following totals from its operating budgets: Prepare a budgeted income statement for the year ended December 31, 2016, assuming that income from operations is taxed at a rate of 30%.Selling and administrative expense budget and budgeted income statement Budgeted selling and administrative expenses for Scottsdale Styles Inc. in P7-4 for the year ended December 31, 2016, were as follows: Required: 1. Prepare a selling and administrative expenses budget, in good form, for the year 2016. 2. Using the information above and the budgets prepared in P7-4, prepare a budgeted income statement for the year 2016, assuming an income tax rate of 30%.Using a separate columnar worksheet or Excel worksheet, prepare a Cash Budget by month for the quarter ending September 30, 2021, from the following data obtained from the CONSCIOÜNESS Company. Support your solution with schedules of estimated receipts and payments. August P 16,000 150,000 July September Cash Sales P 12,000 P 18,000 Credit Sales Purchases 110,000 120,000 90,000 120,000 110,000 Operating expenses Interest expense 15,000 18,000 16,000 2,000 Credit sales are collected 50% in the month of sales, 40% on the month following, 8% in the second month following and 2% uncollectible. Credit sales for May and June are expected to be P100,000 and P90,000, respectively. Purchases of merchandise, all on account, are paid 60% in the month of purchase and 40% in the month following. Purchases for June are estimated at P80,000. Expenses include depreciation of P2,000 monthly, and are paid in the month incurred. Cash balance on June 30, 2021.
- Following is Budgeted Data of R Ltd. Prepare Cash Budget for the quarter ended 31st March 2007. Month Sales Purchases Wages Misc.Exps November’06 1,30,000.00 98,000.00 12,000.00 8,000.00 December’06 1,50,000.00 1,10,000.00 15,000.00 9,000.00 January’07 90,000.00 1,14,000.00 9,000.00 7,000.00 February’07 1,26,000.00 1,16,000.00 12,000.00 14,000.00 March’07 98,000.00 85,000.00 8,000.00 7,000.00 Additional Information: - 1. Cash on Hand as on 1st January 2007 is Rs 5,000/-. Sales: - 20% realized in the month of sale, discount allowed 2% and balance is subsequent 2 months. 2. Purchases are paid for in the following month of supply. 3. Wages are 50% in arrears and paid in subsequent month. 4. Miscellaneous Expenses are paid a month in arrears. 5. Rent of Rs 1,000 per month is paid quarterly in advance. 6. Income Tax is due on 15th March 2007 Rs 21,500/-. 7. Interest on…g. Prepare a schedule of cash collected from customers for the quarter ended March 31, 20X1. h. Prepare the cash budget for the quarter ended March 31, 20X1.Budgeted Income Statement and Balance SheetAs a preliminary to requesting budget estimates of sales, costs, and expenses for the fiscal year beginning January 1, 20Y9, the following tentative trial balance as of December 31, 20Y8, is prepared by the Accounting Department of Mesa Publishing Co.: Cash$ 26,000Accounts Receivable23,800Finished Goods16,900Work in Process4,200Materials6,400Prepaid Expenses600Plant and Equipment82,000Accumulated Depreciation—Plant and Equipment$ 32,000Accounts Payable14,800Common Stock, $1.50 par30,000Retained Earnings83,100$159,900$159,900Factory output and sales for 20Y9 are expected to total 3,800 units of product, which are to be sold at $120 per unit. The quantities and costs of the inventories at December 31, 20Y9, are expected to remain unchanged from the balances at the beginning of the year.Budget estimates of manufacturing costs and operating expenses for the year are summarized as follows:Estimated Costs and ExpensesFixed(Total for…
- From the information below, prepare a cash budget for a company for April, May, and June 2019 in a columnar form. Month Sales Purchases Wages Exp. Jan. (actual) 80,000 45,000 20,000 5,000 Feb. (actual) 80,000 40,000 18,000 6,000 Mar. (actual) 75,000 42,000 22,000 6,000 Apr. Budget 90,000 50,000 24,000 6,000 May Budget 85,000 45,000 20,000 6,000 Jun. Budget 80,000 35,000 18,000 5,000 You are further informed that: 10% of purchases and 20% of sales are for cash. The average collection period of the company is half a month and credit purchases are paid off regularly after one month. Wages are paid half monthly and the rent of $500, excluded in expense, is paid monthly. Cash and bank balance on April 1 was $15,000, and the company aims to keep it below this figure at the end of every month. The excess cash is placed in fixed deposits.The following information was taken from Swifty Corporation cash budget for the month of July: Beginning cash balance $95000 Cash receipts 91000 Cash disbursements 129000 If the company has a policy of maintaining an end of the month cash balance of $95000, the amount the company would have to borrow is $57000. $38000. $19000. $24000. The following information was taken from Swifty Corporation cash budget for the month of July: Beginning cash balance $95000 Cash receipts 91000 Cash disbursements 129000 If the company has a policy of maintaining an end of the month cash balance of $95000, the amount the company would have to borrow is $57000. $38000. $19000. $24000. The following information was taken from Swifty Corporation cash budget for the month of July: Beginning cash balance $95000 Cash receipts 91000 Cash disbursements 129000 If the company has a policy of maintaining an end of the month cash balance of $95000, the…Relevant data from Picta Company’s operating budgets are presented below. The company’s financial year ends on 30 June. Quarter 1Quarter 2Sales$248,470$251,539Direct material purchases120,295128,832Direct labor76,55374,289Manufacturing overhead26,00024,400Selling and administration expenses33,50033,500Depreciation included in selling and administration expenses 2,000 2,500 Collection from customers230,524220,116Cash payments for purchases114,345118,346 Additional data:Equipment was sold in July for $8,000 and $4,500 in November. Dividends of $5,500 were paid in August. The beginning cash balance was $80,395 and a required minimum cash balance per quarter is $60,000. The company has a 15% open line of credit for $70 000 with their bank. Required: a) Use this information to prepare a cash budget for the first two quarters of the year. bi) Briefly comment on Picta Company’s expected cashflow position in the first two quarters of the year.