4. The Income and Expense details of L & M Co. Are given below. Prepare the Business Budget for the year ended December 2020. Operating Income Q1 sales Q2 Sales Q3 Sales Total Operating Income Non-Operating Income Total Non-Operating Expenses Miscellenous Rent Water Electricity Insurance Depreciation Telephone Office Supplies Total Operating Expenses Total Expenses Net Income Actual P 37,500 45,000 40,000 10,000 5,000 25,000 3,500 8,000 12,000 25,000 12,000 5,000 Budget 37,000 40,000 38,000 8,000 4,500 23,000 3,000 6,000 10,000 21,800 10,000 4,500 Differences
Q: Suppose the spot exchange rate for the Canadian dollar is Can$1.07 and the six-month forward rate is…
A: A spot rate, often known as spot pricing, is the current price offered for the immediate settlement…
Q: QUESTION 9 Investors can form complete portfolios out of 2 assets: a T-bill and a risky portfolio P.…
A: Solution:- Risk averse means a person who hates risk. A risk-averse person does not want to take as…
Q: Abdullah is concerning about buying of a gift shop operating at AEON Shah Alam. Based on the shop…
A: Particulars Amount Revenue RM 2,75,000.00 Cost of Good sold RM 65,000.00 Wages and…
Q: Critically discuss the use of forwards vs. futures instruments within firms and how these can be…
A: Financial instruments known as derivatives derive their values from other securities like shares,…
Q: Consider the following information and then calculate the required rate of return for the Global…
A: Solution:- Capital Asset Pricing Model (CAPM) is a model which gives a formula to calculate the…
Q: AMC’s bonds currently sell for $1,200. They pay a $130 semi-annual coupon, have a 9-year maturity,…
A: Given Current price of bond is $1200 coupon payment is $130
Q: Peter Piper has applied for a mortgage of $124,000. Interest is computed at 6.5 percent compounded…
A: Loans are paid by the monthly equal and fixed payments and these payments carry the payment for…
Q: (IRR calculation) Determine the internal rate of return on the following project: An initial outlay…
A: The internal rate of return shows the return on an investment made by an investor. It is helpful in…
Q: L requires an initial outlay at t = 0 of $50,592, its expected cash inflows are $9,000 per year for…
A: IRR is the internal rate of return where the net present value is zero and net present value of cash…
Q: CCC Corp has a beta of 1.5 and is currently in equilibrium. The required rate of return on the stock…
A:
Q: Rose deposits P20,000 into a fund that earns 7.5% interest payable quarterly while Jack deposits at…
A:
Q: Consider a 1-year option with exercise price $65 on a stock with annual standard deviation 15%. The…
A: Given Exercise price of stock is $65 SD is 15% Tbill rate is 3%
Q: Can you show how to calculate the variance step by step without using excel
A: Meaning of Variance : It is a measure of spread of values (in this case return of Philips) from the…
Q: Lease versus Buy Big Sky Mining Company must install $1.5 million of new machinery in its Nevada…
A: concept. Lease or buy decision involves use of capital budgeting technique of net present value…
Q: A company is considering the purchase of a piece of equipment that will have the following •…
A: Capitalized cost is the today value of all cost that are going to occur in the life of the equipment…
Q: Suppose Acap Corporation will pay a dividend of $2.83 per share at the end of this year and $3 You…
A: Cost of stock today can be found as the present value of dividend that are to received in the future…
Q: Company A's simple EPS is $1 and diluted EPS is $.50. Company B's simple EPS is $1.5 but his diluted…
A: EPS & Diluted EPS: These are used to measure the profitability of any company. EPS indicates how…
Q: Narda's parents made P20,000 into an account that will earn an effective interest rate of 8% for 4…
A: Effective interest rate is the actual rate earned after considering the effect of compounding.…
Q: (Payback period, net present value, profitability index, and internal rate of return calculations)…
A: Initial Cash Outlay $ 90,000.00 Expected CashFlow $ 24,300.00 Time…
Q: f. To help you reach your $1,000 goal, your father offers to give you $400 in one year. You will get…
A: The future value of an amount is the value of the investment after certain time period when invested…
Q: Explain how capital adequacy requirements may affect a commercial bank’s dividend payout and growth…
A: Capital adequacy requirement refers to the amount of capital a bank must have as per the requirement…
Q: Use the following tax table to determine how much income tax is paid on 915000 of taxable income.…
A: Rate Taxable Income Bracket 10% $0 to $9,325 15% $9,325 to $37,950 25% $37,950 to $91,900…
Q: SDJ, Inc., has net working capital of $1,175, current liabilities of $6,981, and inventory of…
A: Net working capital = $1,175 Current liabilities = $6,981 Inventory = $1,092
Q: Based upon the following cash flows, Using IRR should Famous Al’s Cookie Company introduce a new…
A: Solution:- Internal Rate of Return (IRR) is the rate of return the project is yielding. It can be…
Q: FCFE Valuation A company's most recent free cash flow to equity was $130 and is expected to grow at…
A: concept and formula. value of firm = FCFE(1+g)ke-g where , FCFE = free cash flow to equity g=…
Q: A stock has an expected return of 10.2 percent. The expected return on the market is 9 percent and…
A: Expected Return = Risk Free Rate +Beta ×Market Return-Risk Free Rate Expected Return is 10.2% Market…
Q: Question 69 If the discount rate is known, what else is required to value an investment? O a. The…
A: Value of investment is calculated using following variables in the following equation Present value…
Q: The Ivanhoe Products Co. currently has debt with a market value of $250 million outstanding. The…
A: Here, To Find: Cost of debt =? Cost of preferred stock =? Cost of common stock =?
Q: A zero coupon bond with a face value of $21,000 matures in 11 years. What should the bond be sold…
A: Zero Coupon bonds: Bonds that experience more fluctuations in market value than coupon bonds and…
Q: North Side Corporation is expected to increase its dividends at 8 percent (annual) rate over the…
A: The increased dividend can be calculated using the formula: Dividend to be paid next year = Dividend…
Q: A stock has a beta of 1.1. The expected return on the market is 6.18 percent and the risk free rate…
A: Expected Return = Risk Free Rate + Beta ×Market Return -Risk Free Rate Risk Free Rate is 2% Beta is…
Q: The sales price is $150,000. The buyer is obtaining a 90% conventional loan for 15 years. The factor…
A: Sale price = $150000 Down payment = 90%*$150000 = $135000 Factor of 9.28 means that $9.28 is given…
Q: Item Beginning Ending Inventory $ 12,435 $ 15,615 Accounts receivable 6,120 6,287 Accounts…
A: The operating cycle represents the number of days takes the company to purchase the goods, sell the…
Q: What is the cost of debt for Foggy Futures Weather Forecasters?The firm is in the 40% tax…
A: Par Value = $1,000 Coupon rate = 8% Time Period = 20 years Discount = $30 Flotation costs = $30
Q: Soft and Cuddly is considering a new toy that will produce the following cash flows. Should the…
A: The IRR is the actual rate of return from a project of investment. The IRR considers only the cash…
Q: Because it fumes at room temperatures, hydrochloric acid creates a very corrosive work environment.…
A: Data given: Old machine: Expected operating cost for the next year=$49000 n=1 year Challenger:…
Q: Apple Inc. is expected to pay a dividend of $1.57 at the end of the year. The required rate of…
A: To calculate the stock's price we will use the below formula Stock's price = D1/(r-g) Where D1 -…
Q: We are evaluating a project that costs $728,000, has a life of twelve years, and has no salvage…
A: NPV is defined as the sum of the present values of all future cash inflows less the sum of the…
Q: Maddux Corporation has EBIT of $725,000 per year that is expected to continue in perpetuity. The…
A: First we need to calculate net income from EBIT. Net income =EBIT(1-Tax) Value of unlevered…
Q: he Weidmans want to save $45,000 in 3 years for a down payment on a house. If they make monthly…
A: Monthly payments that are required to meet the goal are periodic deposits made in view of reaching a…
Q: Pam has just invested $2,500 in a 10-year 1.5% coupon bond with semi-annual coupons. The bond will…
A: Pam has bought the bond for $2500, Number of years to maturity is 10 years with coupon rate of 1.5%…
Q: Finding the Price of Semiannual Bonds Let us compute the price of a sample bond. Suppose the bonds…
A: Price of bond is present value of coupon payment and present value of par value of bonds that is…
Q: Check Bandor Furniture pays a constant annual dividend. Last year, the dividend yield was 4.9…
A: Compute the amount of annual dividend, using the equation as shown below: Annual dividend=Stock…
Q: Why doesn’t an issuer of an asset-backed security seek the highest credit rating of triple A?
A: Asset-backed securities (ABSs) are financial instruments that are supported by revenue assets…
Q: 58 A e) f) 8) B C D Calculate the debt to equity ratio for both companies at the end of 2024.…
A: Debt equity ratio and debt ratio are leverage ratos which are based on the proportion of debt and…
Q: selling
A: According to the model S(Spot Price+Put Price P = PV of Strike Price X +Call Price.C S=60,C=5,P=3…
Q: According to portfolio theory, which of the following statements is true about the Capital…
A: CAL Each single combination of risky assets and risk free asset are included in the set of…
Q: Cori’s Corporation has an equity value of $14,735. Long-term debt is $8,300. Net working capital,…
A: Fixed Assets = $18,440 Long term debt = $8,300 Current liabilities = $2,325 Shareholders' Equity =…
Q: XYZ Manufacturing Corporation currently has production equipment that has 4 years of remaining life.…
A: Net Investment (NINV) is the total cost incurred at time "0" to start the project or buy the…
Q: You have decided to get a $5,000,000 balloon mortgage with the following characteristics: 5 years…
A: Here, Particulars Values Loan Amount (PV) $5000000.00 Interest rate 10.00% Ballon payment…
Step by step
Solved in 2 steps with 2 images
- Splish Company has accumulated the following budget data for the year 2022: 1. 2. 3. 4. 5. 6. 19 Sales: 27,900 units; unit selling price $82 Cost of one unit of finished goods: direct materials, 2 kg at $5 per kilogram; direct labour, 3 hours at $13 per hour; and manufacturing overhead, $6 per direct labour hour Inventories (raw materials only): beginning, 9,900 kg; ending, 14,100 kg Raw materials cost: $5 per kilogram Selling and administrative expenses: $201,000 Income taxes: 30% of income before income taxesPrepare the Pro-Forma Statement of Financial Position for the year ending 31 December 2023 INFORMATIONSibiya ProjectsStatement of Comprehensive Income for the year ended 31 December 2022 RSales 10 000 000Cost of sales (5 750 000)Gross profit 4 250 000Variable, selling and administrative costs (1 500 000)Fixed selling and administrative costs (500 000)Net profit 2 250 000 Statement of Financial Position for the year ended 31 December 2022ASSETS RNon-current assets 800 000Property, plant and equipment 800 000 Current assets 3 400 000Inventories 1 600 000Accounts receivable 600 000Cash 1 200 000TOTAL ASSETS 4 200 000 EQUITY AND LIABILITIESEquity 3 760 000 Current liabilities 440 000Accounts payable 440 000TOTAL ASSETS AND LIABILITIES 4 200 000 Additional informationA. The sales budget for 2023 is as follows:First Quarter Second Quarter Third Quarter Fourth QuarterR2 625 000 R2 750 000 R2 875 000 R2 750 000 B. 90% of sales is collected in the quarter of the sale and 10% in the quarter…Prepare a Budgeted Statement of Financial Position as at 31 December 2022 using the below information: Statement of comprehensive income for the year ended 31 December 2021Sales 10 000 000Cost of sales (5 750 000)Gross profit 4 250 000Variable selling and administrative expenses (1 500 000)Fixed selling and administrative expenses (500 000)Net profit 2 250 000 Statement of financial position as at 31 December 2021ASSETSNon-current assets 800 000Property, plant and equipment 800 000Current assets 3 400 000Inventories 1 600 000Accounts receivable 600 000Cash 1 200 000 4 200…
- 1. What items are typically submitted as part of the budget or annual plan? Marketing plan Capital plan Employee plan Both A & Bq.Prepare the budgeted income statement for Skulas, Inc., for January 2018.Sales Revenue Cost of Goods Sold Income from Operations Selling and Administrative Expenses Budgeted Income Statement For the Year Ending December 31, 2022 Income from Operations Interest Expense Income before Income Taxes Interest Expense Not Income (Loss) $ 326,400 (166,380) i 160,020 88,500 i 71,520 (4,130 67,390 (13,478 53912
- Prepare a vertical analysis scheduleHere is the operating data for Yalis Cleaning, Inc.:2021 2020Service revenue $523,000 $476,000Operating expenses 385,500 319,800Income tax expense 34,375 39,050Net income $103,125 $117,150PurposeThe purpose of this problem is to demonstrate an understanding of preparing a vertical analysis schedule.InstructionsAfter analyzing the transactions, prepare a vertical analysis schedule for the company for 2021 and 2020 using service revenueas the base amount. Round percentages to two decimal places.GuidanceFor formatting guidance, see the vertical analysis examples that are provided in Chapter 13 of the textbook.Statement of comprehensive income for the year ended 31 December 2021Sales 10 000 000Cost of sales (5 750 000)Gross profit 4 250 000Variable selling and administrative expenses (1 500 000)Fixed selling and administrative expenses (500 000)Net profit 2 250 000 Additional information:1. The sales budget for 2022 is as follows:First quarter R2 625 000Second quarter R2 750 000Third quarter R2 875 000Fourth quarter R2 750 0002. 90% of the sales is collected in the quarter of the sale and 10% in the quarter following the sale.3. The gross margin ratio for 2022 is expected to be the same as for 2021.4. Inventory is purchased in the quarter of the expected sale. Eighty (80%) of inventory purchases is paid for in thequarter of purchase and twenty percent (20%) is paid for in the quarter following the purchase.5. The inventories balance at the end of each quarter is expected to be the same as the end of the last quarter of2021 viz. R1 600 000.6. Variable selling and administrative expenses will…Presented below are the year-end balance of the assets and liabilitiespertaining to Starlight Merchandising 2020 2019Cash P150,000 P120,000Equity investment at FVPL 260,000 230,000AR, net 360,000 400,000Inventories 705,000 635,000Prepaid Expenses 130,000 128,000Accounts payable 182,000 136,000Other current liabilities 141,000 125,000Bonds Payable 200,000 200,000Additional investment made by the owner during 2020 was P150,000 but a P200,000 personal liability was paid out of company's funds. What is the company's profit or loss for the year ended December 31, 2020? 30,000 800,000 Answer not given 140,000 700,000
- 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.4G . 4G S 9:58 以令 Shrek & Fiona Company Statement of Financial Position As of December 31, 2020 Current Assets Current Liabilities Cash 18,000 Accounts Payable (N2) 240,000 Accounts Receivable (N1) Taxes Payable Dividends Payable 1,192,000 13,200 Less: Uncollectible accounts (22,400) 1,169,600 500,000 Inventories Total Current Liabilities 753,200 Raw Materials (12,000 pounds) 30,000 Finished Goods (4,000 units) 140,000 170,000 Total Current Assets 1,357,600 Stockholder's Equity Common Stock (100,000 shares) 500,000 Non-current Assets Retained Earnings 360,400 Property, plant, and equipment 320,000 Total Stockholder's Equity 860,400 Less: Accumulated depreciation (64,000) 256,000 Total Assets 1,613,600 Total Liabilities and SHE 1,613,600 N1 2020 3rd quarter sales P2,500,000 2020 4th quarter sales P3,100,000 200,000 992,000 1,192,000 75,000 165,000 N2 2020 3rd quarter purchases P300,000 2020 4th quarter purchases P330,000 240,000 1. Estimated unit sales for the first quarter of 2021 is…You are provided with the following information taken from Sage Hill Inc's March 31, 2027, balance sheet. Cash Accounts receivable Inventory Property, plant, and equipment, net of depreciation Accounts payable Common stock Retained earnings 1 2 3. 5. 6. 7. Additional information concerning Sage Hill Inc. is as follows. Gross profit is 24% of sales. Actual and budgeted sales data: March (actual) April (budgeted) March April $18.840 $47.100 $62460 $12,280 72.700 23.120 37,100 123,400 22,910 Sales are both cash and credit, Cash collections expected in April are: 152.900 12.320 (40% of $47.100) (60% of $72,700) Half of a month's purchases are paid for in the month of purchase and half in the following month Cash disbursements expecte Purchases March Purchases April $22,910 28,910 $51820 Cash operating costs are anticipated to be $12,110 for the month of April. Equipment costing $2,530 will be purchased for cash in April. The company wishes to maintain a minimum cash balance of $12,240. An…