Excel_Chapter_03_Student
14 Pages

Excel_Chapter_03_Student

Course Number: ECON 101, Spring 2011

College/University: North Shore

Word Count: 1228

Rating:

Document Preview

SpreadsheetTemplates FoundationsofFinancialManagem MAINMENUCHAPTER3 Problem 3-19 Problem 3-20 Problem 3-33 Problem 3-34 Spreadsheet Templates by Block and Hirt Copyright 2008 McGraw-Hill/Irwin and Info-Labs. (www.info-labs.com) plates ialManagement TER3 Problem 3-21 lock and Hirt abs. (www.info-labs.com) FoundationsofFinancialManagement BlockandHirtTwelfthEdition Problem 3-19 Objective Overall ratio...

Unformatted Document Excerpt
Coursehero >> Massachusetts >> North Shore >> ECON 101

Course Hero has millions of student submitted documents similar to the one
below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.

Course Hero has millions of student submitted documents similar to the one below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.

3-19 Problem SpreadsheetTemplates FoundationsofFinancialManagem MAINMENUCHAPTER3 Problem 3-20 Problem 3-33 Problem 3-34 Spreadsheet Templates by Block and Hirt Copyright 2008 McGraw-Hill/Irwin and Info-Labs. (www.info-labs.com) plates ialManagement TER3 Problem 3-21 lock and Hirt abs. (www.info-labs.com) FoundationsofFinancialManagement BlockandHirtTwelfthEdition Problem 3-19 Objective Overall ratio analysis Student Name: Course Name: Student ID: Course Number: The balance sheet for Bryan Corporation is shown below. Sales for the year were $3,040,000, with 75 percent of sales sold on credit. BRYAN CORPORATION Balance Sheet 200X Assets Cash Accounts receivable Inventory Plant and equipment Total assets Liabilities and Stockholders' Equity Accounts payable $220,000 Accrued taxes 80,000 Bonds payable (long term) 118,000 Common stock 100,000 Paid-in-capital 150,000 Retained earnings 282,000 Total liabilities and $950,000 stockholders' equity $950,000 $50,000 280,000 240,000 380,000 Compute the following ratios: a. Current ratio. b. Quick ratio. c. Debt-to-total-assets ratio. d. Asset turnover. e. Average collection period. Copyright 2008 McGrawHill/ Irwin Spreadsheet Template by Block and Hirt Problem: 3-19 Solution Problem 3-19 Instructions Enter formulas to calculate the following ratios. If possible, use cell references to the balance sheet. a. Current ratio FORMULA b. Quick ratio FORMULA c. Debt-to-total-assets ratio FORMULA d. Asset turnover FORMULA e. Average collection period FORMULA Copyright 2008 McGrawHill/ Irwin Spreadsheet Template by Block and Hirt Problem: 3-19 FoundationsofFinancialManagement BlockandHirtTwelfthEdition Problem 3-20 Objective Debt-utilization ratios Student Name: Course Name: Student ID: Course Number: The Lancaster Corporation's income statement is given below. a. What is the times-interest-earned ratio? b. What would be the fixed-charge-coverage ratio? LANCASTER CORPORATION Sales Cost of goods sold Gross profit Fixed charges (other than interest) Income before interest and taxes Interest Income before taxes Taxes (35%) Income after taxes Copyright 2008 McGrawHill/ Irwin $200,000 116,000 84,000 24,000 60,000 12,000 48,000 16,800 $31,200 Spreadsheet Template by Block and Hirt Problem: 3-20 Solution Problem 3-20 Instructions Enter formulas to calculate the following ratios. If possible, use cell references to the income statement. a. Times interest earned FORMULA b. Fixed charge coverage FORMULA Copyright 2008 McGrawHill/ Irwin Spreadsheet Template by Block and Hirt Problem: 3-20 FoundationsofFinancialManagement BlockandHirtTwelfthEdition Problem 3-21 Objective Debt utilization and Du Pont system of analysis Student Name: Course Name: Student ID: Course Number: Using the income statement for J.Lo Wedding Gowns, compute the following ratios: a. The interest coverage. b. The fixed charge coverage. The total assets for this company equal $160,000. Set up the equation for the Du pont system of ratio analysis, and compute the answer to part c below. c. Return on assets (investment). J.Lo Wedding Gowns Income Statement Sales Less: Cost of goods sold Gross profit Less: Selling and administrative expense Less: Lease expense Operating profit* Less: Interest expense Earnings before taxes Less: Taxes (40%) Earnings after taxes $200,000 90,000 110,000 40,000 10,000 $60,000 5,000 $55,000 22,000 $33,000 *Equals income before interest and taxes. Copyright 2008 McGrawHill/ Irwin Spreadsheet Template by Block and Hirt Problem: 3-21 Solution Problem 3-21 Instructions Enter formulas to calculate the following ratios. If possible, use cell references to the income statement. a. Times interest earned FORMULA b. Fixed charge coverage FORMULA c. Return on assets FORMULA Copyright 2008 McGrawHill/ Irwin Spreadsheet Template by Block and Hirt Problem: 3-21 FoundationsofFinancialManagement BlockandHirtTwelfthEdition Problem 3-33 Objective Comparing all the ratios Student Name: Course Name: Student ID: Course Number: Using the financial statements for the Snider Corporation, calculate the 13 basic ratios found in the chapter. SNIDER CORPORATION Balance Sheet December 31, 2007 Assets Current assets: Cash Marketable securities Accounts receivable (net) Inventory Total current assets Investments Plant and equipment Less: Accumulated depreciation Net plant and equipment Total assets Liabilities and Stockholders' Equity Current liabilities: Accounts payable Notes payable Accrued taxes Total current liabilities Long-term liabilities: Bonds payable Total liabilities Copyright 2008 McGrawHill/ Irwin $50,000 20,000 160,000 200,000 $430,000 60,000 600,000 -190,000 410,000 $900,000 $90,000 70,000 10,000 170,000 150,000 $320,000 Spreadsheet by Template Block and Hirt Problem: 3-33 Stockholders' equity: Preferred stock, $50 par value Common stock, $1 par value Capital paid in excess of par Retained earnings Total stockholders' equity Total liabilities and stockholders' equity 100,000 80,000 190,000 210,000 580,000 $900,000 SNIDER CORPORATION Income Statement For the Year Ending December 31, 2007 Sales (on credit) Less: Cost of goods sold Gross profit Less: Selling and administrative expenses Operating profit (EBIT) Less: Interest expense Earnings before taxes (EBT) Less: Taxes Earnings after taxes (EAT) $1,980,000 1,280,000 700,000 475,000 * 225,000 25,000 200,000 80,000 $120,000 *Includes $35,000 in lease payments. Copyright 2008 McGrawHill/ Irwin Spreadsheet Template by Block and Hirt Problem: 3-33 Solution Problem 3-33 Instructions Enter formulas to calculate the ratios from this chapter. Profitability ratios Profit margin Return on assets (investment) Return on equity FORMULA FORMULA FORMULA Assets utilization ratios Receivable turnover Average collection period Inventory turnover Fixed asset turnover Total asset turnover FORMULA FORMULA FORMULA FORMULA FORMULA Liquidity ratios Current ratio Quick ratio FORMULA FORMULA Debt utilization ratios Debt to total assets Times interest earned Fixed charge coverage FORMULA FORMULA FORMULA Copyright 2008 McGrawHill/ Irwin Spreadsheet Template by Block and Hirt Problem: 3-33 FoundationsofFinancialManagement BlockandHirtTwelfthEdition Problem 3-34 Objective Ratio computation and analysis Student Name: Course Name: Student ID: Course Number: Given the financial statements for Jones Corporation and Smith Corporation shown here: a. To which one would you, as credit manager for a supplier, approve the extension of (short-term) trade credit? Why? Compute all ratios before answering. b. In which one would you buy stock? Why? JONES CORPORATION Current Assets Cash Accounts receivable Inventory Long-Term Assets Fixed Assets Less: Accumulated Depreciation Net fixed assets* Total assets Liabilities $20,000 Accounts payable 80,000 Bonds payable (long-term) 50,000 Stockholders' Equity $500,000 Common stock -150,000 Paid-in capital 350,000 Retained earnings $500,000 Total liabilities and equity Sales (on credit) Cost of goods sold Gross profit Selling and Administrative expense Less: Depreciation expense Operating Profit Interest expense Earnings before taxes Tax expense Net Income $100,000 80,000 $150,000 70,000 100,000 $500,000 $1,250,000 750,000 500,000 257,000 50,000 193,000 8,000 185,000 92,500 $92,500 * Use net fixed assets in computing fixed asset turnover. Includes $7,000 in lease payments. SMITH CORPORATION Copyright 2008 McGrawHill/ Irwin Spreadsheet Template by Block and Hirt Problem: 3-34 Current Assets Cash Marketable securities Accounts receivable Inventory Long-Term Assets Fixed Assets Less: Accumulated Depreciation Net fixed assets* Total assets Liabilities $35,000 Accounts payable 7,500 Bonds payable (long-term) 70,000 75,000 Stockholders' Equity $500,000 Common stock -250,000 Paid-in capital 250,000 Retained earnings $437,500 Total liabilities and equity Sales (on credit) Cost of goods sold Gross profit Selling and Administrative expense Less: Depreciation expense Operating Profit Interest expense Earnings before taxes Tax expense Net Income $75,000 210,000 $75,000 30,000 47,500 $437,500 $1,000,000 600,000 400,000 224,000 50,000 126,000 21,000 105,000 52,500 $52,500 * Use net fixed assets in computing fixed asset turnover. Includes $7,000 in lease payments. Copyright 2008 McGrawHill/ Irwin Spreadsheet Template by Block and Hirt Problem: 3-34 Solution Problem 3-34 Instructions Enter formulas to calculate the following ratios. If possible, use cell references to the financial statements. Jones and Smith Comparison One way of analyzing the situation for each company is to compare the respective ratios for each on, examining those ratios which would be most important to a supplier or short-term lender and a stockholder. Profit margin Return on assets Return on equity Receivable turnover Average collection period Inventory turnover Fixed asset turnover Total asset turnover Current ratio Quick ratio Debt to total assets Times interest earned Fixed charge coverage Jones Corp. FORMULA FORMULA FORMULA FORMULA FORMULA FORMULA FORMULA FORMULA FORMULA FORMULA FORMULA FORMULA FORMULA Smith Corp. FORMULA FORMULA FORMULA FORMULA FORMULA FORMULA FORMULA FORMULA FORMULA FORMULA FORMULA FORMULA FORMULA a. To which one would you, as credit manager for a supplier, approve the extension of (short-term) trade credit? Why? b. In which one would you buy stock? Why? Copyright 2008 McGrawHill/ Irwin Spreadsheet Template by Block and Hirt Problem: 3-34

Find millions of documents on Course Hero - Study Guides, Lecture Notes, Reference Materials, Practice Exams and more. Course Hero has millions of course specific materials providing students with the best way to expand their education.

Below is a small sample set of documents:

North Shore - ECON - 101
SpreadsheetTemplatesFoundationsofFinancialManagemMAINMENUCHAPTER4Problem 4-22Problem 4-24Spreadsheet Templates by Block and HirtCopyright 2008 McGraw-Hill/Irwin and Info-Labs. (www.info-labs.com)platesialManagementTER4Problem 4-26lock and Hirt
North Shore - ECON - 101
SpreadsheetTemplatesFoundationsofFinancialManagemMAINMENUCHAPTER5Problem 5-4Problem 5-10Spreadsheet Templates by Block and HirtCopyright 2008 McGraw-Hill/Irwin and Info-Labs. (www.info-labs.com)platesialManagementTER5lock and Hirtabs. (www.info
North Shore - ECON - 101
SpreadsheetTemplatesFoundationsofFinancialManagemMAINMENUCHAPTER11Problem 11-16Problem 11-17Spreadsheet Templates by Block and HirtCopyright 2008 McGraw-Hill/Irwin and Info-Labs. (www.info-labs.com)platesialManagementTER11Problem 11-20lock and
North Shore - ECON - 101
SpreadsheetTemplatesFoundationsofFinancialManagemMAINMENUCHAPTER12Problem 12-1Problem 12-20Spreadsheet Templates by Block and HirtCopyright 2008 McGraw-Hill/Irwin and Info-Labs. (www.info-labs.com)platesialManagementTER12Problem 12-23lock and H
North Shore - ECON - 101
SpreadsheetTemplatesFoundationsofFinancialManagemMAINMENUCHAPTER13Problem 13-20Problem 13-23Spreadsheet Templates by Block and HirtCopyright 2008 McGraw-Hill/Irwin and Info-Labs. (www.info-labs.com)platesialManagementTER13Problem 13-23lock and
North Shore - ECON - 101
SpreadsheetTemplatesFoundationsofFinancialManagemMAINMENUCHAPTER15Problem 15-6Problem 15-12Spreadsheet Templates by Block and HirtCopyright 2008 McGraw-Hill/Irwin and Info-Labs. (www.info-labs.com)platesialManagementTER15Problem 15-15lock and H
North Shore - ECON - 101
SpreadsheetTemplatesFoundationsofFinancialManagemMAINMENUCHAPTER16Problem 16-4Problem 16-17Spreadsheet Templates by Block and HirtCopyright 2008 McGraw-Hill/Irwin and Info-Labs. (www.info-labs.com)platesialManagementTER16Problem 16-17lock and H
North Shore - ECON - 101
SpreadsheetTemplatesFoundationsofFinancialManagemMAINMENUCHAPTER17Problem 17-10Problem 17-18Spreadsheet Templates by Block and HirtCopyright 2008 McGraw-Hill/Irwin and Info-Labs. (www.info-labs.com)platesialManagementTER17Problem 17-18lock and
North Shore - ECON - 101
SpreadsheetTemplatesFoundationsofFinancialManagemMAINMENUCHAPTER18Problem 18-10Problem 18-16Spreadsheet Templates by Block and HirtCopyright 2008 McGraw-Hill/Irwin and Info-Labs. (www.info-labs.com)platesialManagementTER18Problem 18-17lock and
North Shore - ECON - 101
SpreadsheetTemplatesFoundationsofFinancialManagemMAINMENUCHAPTER19Problem 19-11Problem 19-18Spreadsheet Templates by Block and HirtCopyright 2008 McGraw-Hill/Irwin and Info-Labs. (www.info-labs.com)platesialManagementTER19Problem 19-20lock and
North Shore - ECON - 101
SpreadsheetTemplatesFoundationsofFinancialManagemMAINMENUCHAPTER20Problem 20-5Problem 20-11Spreadsheet Templates by Block and HirtCopyright 2008 McGraw-Hill/Irwin and Info-Labs. (www.info-labs.com)platesialManagementTER20Problem 20-11lock and H
North Shore - ECON - 101
SpreadsheetTemplatesFoundationsofFinancialManagemMAINMENUCHAPTER21Problem 21-6Problem 21-8Spreadsheet Templates by Block and HirtCopyright 2008 McGraw-Hill/Irwin and Info-Labs. (www.info-labs.com)platesialManagementTER21Problem 21-8lock and Hir
Berkeley - ENGINEERIN - 115
Problem Set 1E115 - Thermodynamics - Fall 2011Due: xx/yy1. For the following list of systems, determine if each is open, closed, or isolated. You may choose to provide justicationfor your answer if you feel it is necessary (7 pts). For this problem, f
Berkeley - MSE - 113
UNIVERSITY OF CALIFORNIACollege of EngineeringDepartment of Materials Science and EngineeringFall 2011MSE 113Mechanical Behavior of MaterialsProfessor RitchiePROBLEM SET 1Problem 1 (20 points)Assuming a linear elastic pressure vessel pressurized
Berkeley - MSE - 102
MSE 102 Fall 2011Problem Set 4 SolutionsJames MastandreaProblem Set 4 Due Date: 9/22/20111Question 1For this problem we are told that the crystal has symmetry described by plane group 9, c2mm. This planegroup describes rectangular systems. Since th
Alexandria University - CIVIL ENGI - 3
CHAPTER 1INTRODUCTION1.1 IntroductionCold-formed steel products are just what the name con-notes: products that are made bybending a flat sheet of steel at room temperature into a shape that will support more load thanthe flat sheet itself. AISI spec
Hashemite University - ACC - 201
Financial Accounting andAccounting StandardsAccountingChapterChapter1IntermediateAccounting,12thEditionKieso,Weygandt,andWarfieldChapter1 -1PreparedbyCobyHarmon,UniversityofCalifornia,SantaBarbaraChapter 1 Learning Objectives1.Identifythemaj
Hashemite University - ACC - 201
Conceptual FrameworkUnderlying Financial AccountingUnderlyingChapterChapter2IntermediateAccounting12thEditionKieso,Weygandt,andWarfieldChapter2 -1P re p a re d b y C o b yHa rm o n,Unive rs ity o fC a lifo rnia ,S a nta Ba rb a raChapter 2 Lea
Hashemite University - ACC - 201
The Accounting InformationSystemSystemChapterChapter3IntermediateAccounting12thEditionKieso,Weygandt,andWarfieldChapter3 -1Prepared by Coby Harmon, University of California, Santa BarbaraLearning Objectives1.Understand basic accounting te i
Hashemite University - ACC - 201
Income Statement and RelatedInformationInformationChapterChapter4IntermediateAccounting12thEditionKieso,Weygandt,andWarfieldChapter4 -1Prepared by Coby Harmon, University of California, Santa BarbaraLearning Objectives1.Understand theuse an
Hashemite University - ACC - 201
Balance Sheet and Statement of Cash FlowsChapter5Intermediate Accounting 12th Edition Kieso, Weygandt, and WarfieldChapter 5-1Prepared by Coby Harmon, University of California, Santa BarbaraLearning Objectives1. Explain the uses and limitations of
Hashemite University - ACC - 201
Accounting and theAccountingValue of MoneyValueTimeChapterChapter6IntermediateAccounting12thEditionKieso,Weygandt,andWarfieldChapter6 -1Prepared by Coby Harmon, University of California, Santa BarbaraLearning Objectives1.I dentify account
Hashemite University - ACC - 201
Cash and ReceivablesChapterChapter7IntermediateAccounting12thEditionKieso,Weygandt,andWarfieldChapter7 -1Pre d by C Harm Univepareobyon,rsity of California, Santa BarbaraLearning Objectives1.Identify ite s conside d as cash.mre2.Ind
Hashemite University - ACC - 201
Valuation of Inventories: A Cost-Basis ApproachChapter8Intermediate Accounting 12th Edition Kieso, Weygandt, and WarfieldChapter 8-1Prepared by Coby Harmon, University of California, Santa BarbaraLearning Objectives1. 2. 3. 4. 5. 6. 7. 8. 9.Chapte
Hashemite University - ACC - 201
Inventories: Additional ValuationInventories:IssuesIssuesChapterChapter9IntermediateAccounting12thEditionKieso,Weygandt,andWarfieldChapter9 -1Prepared by Coby Harmon, University of California, Santa BarbaraLearning Objectives1.Describeand
Hashemite University - ACC - 201
Acquisition and Disposition ofAcquisitionProperty, Plant, and EquipmentProperty,ChapterChapter1010IntermediateAccounting12thEditionKieso,Weygandt,andWarfieldChapter10-1Prepared by Coby Harmon, University of California, Santa BarbaraLearning
Hashemite University - ACC - 201
Intangible AssetsChapterChapter1212IntermediateAccounting12thEditionKieso,Weygandt,andWarfieldChapter12-1Pre d by C Harm Univepareobyon,rsity of California, Santa BarbaraLearning Objectives1.Describethecharacteristics of intangibleass
Hashemite University - ACC - 201
Current Liabilities andCurrentContingenciesContingenciesChapterChapter1313IntermediateAccounting12thEditionKieso,Weygandt,andWarfieldChapter13-1Pre d by C Harm Univepareobyon,rsity of California, Santa BarbaraLearning Objectives1.De
Hashemite University - ACC - 201
Long-Term LiabilitiesChapterChapter1414IntermediateAccounting12thEditionKieso,Weygandt,andWarfieldChapter14-1Pre d by C Harm Univepareobyon,rsity of California, Santa BarbaraLearning Objectives1.Describetheform proce s associate with i
Hashemite University - ACC - 201
Stockholders EquityChapterChapter1515IntermediateAccounting12thEditionKieso,Weygandt,andWarfieldChapter15-1PreparedbyCobyHarmon,UniversityofCalifornia,SantaBarbaraLearning Objectives1.Discussthecharacteristicsofthecorporateformoforganization.
Hashemite University - ACC - 201
Dilutive Securities andDilutivePer SharePerEarningsChapterChapter1616IntermediateAccounting12thEditionKieso,Weygandt,andWarfieldChapter16-1Pre d by C Harm Univepareobyon,rsity of California, Santa BarbaraLearning Objectives1.Descri
Hashemite University - ACC - 201
InvestmentsChapterChapter1717IntermediateAccounting12thEditionKieso,Weygandt,andWarfieldChapter17-1Pre d by C Harm Univepareobyon,rsity of California, Santa BarbaraLearning Objectives1.I dentify thethre cate s of de see goriebt curit
Hashemite University - ACC - 201
Revenue RecognitionChapterChapter1818IntermediateAccounting12thEditionKieso,Weygandt,andWarfieldChapter18-1Pre d by C Harm Univepareobyon,rsity of California, Santa BarbaraLearning Objectives1.Apply there nuerevecognition principle.
Hashemite University - ACC - 201
Accounting for Income TaxesChapterChapter1919IntermediateAccounting12thEditionKieso,Weygandt,andWarfieldChapter19-1Pre d by C Harm Univepareobyon,rsity of California, Santa BarbaraLearning Objectives1.Identify diffe nce be e pre financ
Hashemite University - ACC - 201
Accounting for Pensions andAccountingPostretirement BenefitsPostretirementChapterChapter2020IntermediateAccounting12thEditionKieso,Weygandt,andWarfieldChapter20-1Pre d by C Harm Univepareobyon,rsity of California, Santa BarbaraLearning
Hashemite University - ACC - 201
Accounting for LeasesChapterChapter2121IntermediateAccounting12thEditionKieso,Weygandt,andWarfieldChapter21-1Pre d by C Harm Univepareobyon,rsity of California, Santa BarbaraLearning Objectives1.Explain thenature e, conom substance and
Hashemite University - ACC - 201
Accounting Changes andAccountingAnalysisAnalysisErrorChapterChapter2222IntermediateAccounting12thEditionKieso,Weygandt,andWarfieldChapter22-1Pre d by C Harm Univepareobyon,rsity of California, Santa BarbaraLearning Objectives1.I de
Hashemite University - ACC - 201
Statement of Cash FlowsChapterChapter2323IntermediateAccounting12thEditionKieso,Weygandt,andWarfieldChapter23-1Pre d by C Harm Univepareobyon,rsity of California, Santa BarbaraLearning Objectives1.Describethepurposeof thestate e of cas
Hashemite University - ACC - 201
Full Disclosure inFinancialFullReportingReportingChapterChapter2424IntermediateAccounting12thEditionKieso,Weygandt,andWarfieldChapter24-1PreparedbyCobyHarmon,UniversityofCalifornia,SantaBarbaraLearning Objectives1.Reviewthefulldisclosurep
University of the Philippines Diliman - IE - 151
IE150ProblemSet1BreakEvenAnalysisInstructions: Write/Type/Printyouranswersonyellowpadorbondpaper(NOA4s).Useadifferentsheetperproblem. Usephrasestodescribewhatyouaredoing.Donotpresentitasjustaseriesofequationsandnumbers. Labeleachstep.Ex:Step1:Setup
University of the Philippines Diliman - IE - 151
IE150ProblemSet2TimeValueofMoneyandMARRInstructions: Write/Type/Printyouranswersonyellowpadorbondpaper(NOA4s).Useadifferentsheetperproblem. Usephrasestodescribewhatyouaredoing.Donotpresentitasjustaseriesofequationsandnumbers. Labeleachstep.Ex:Step1
University of the Philippines Diliman - IE - 151
IE150ProblemSet3PresentandFutureWorthFactorsInstructions: Write/Type/Printyouranswersonyellowpadorbondpaper(NOA4s).Useadifferentsheetperproblem. Usephrasestodescribewhatyouaredoing.Donotpresentitasjustaseriesofequationsandnumbers. Labeleachstep.Ex:
University of the Philippines Diliman - IE - 151
IE150ProblemSet4NPVAnalysisInstructions: Write/Type/Printyouranswersonyellowpadorbondpaper(NOA4s).Useadifferentsheetperproblem. Usephrasestodescribewhatyouaredoing.Donotpresentitasjustaseriesofequationsandnumbers. Labeleachstep.Ex:Step1:SetuptheTot
University of the Philippines Diliman - IE - 151
IE150ProblemSet5NPVAnalysisInstructions: Write/Type/Printyouranswersonyellowpadorbondpaper(NOA4s).Useadifferentsheetperproblem. Usephrasestodescribewhatyouaredoing.Donotpresentitasjustaseriesofequationsandnumbers. Labeleachstep.Ex:Step1:SetuptheTot
University of the Philippines Diliman - IE - 151
IE150ProblemSet6NominalandEffectiveInterestRates,ContinuousCompoundingInstructions: Write/Type/Printyouranswersonyellowpadorbondpaper(NOA4s).Useadifferentsheetperproblem. Usephrasestodescribewhatyouaredoing.Donotpresentitasjustaseriesofequationsandn
University of the Philippines Diliman - IE - 151
IE150ProblemSet7AnnuitiesandGradientsInstructions: Write/Type/Printyouranswersonyellowpadorbondpaper(NOA4s).Useadifferentsheetperproblem. Usephrasestodescribewhatyouaredoing.Donotpresentitasjustaseriesofequationsandnumbers. Labeleachstep.Ex:Step1:S
University of the Philippines Diliman - IE - 151
IE150ProblemSet8NPV,IRR,ERR,Payback2Instructions: Write/Type/Printyouranswersonyellowpadorbondpaper(NOA4s).Useadifferentsheetperproblem. Usephrasestodescribewhatyouaredoing.Donotpresentitasjustaseriesofequationsandnumbers. Labeleachstep.Ex:Step1:Se
University of the Philippines Diliman - IE - 151
IE150ProblemSet9ComparisonofAlternativesInstructions: Write/Type/Printyouranswersonyellowpadorbondpaper(NOA4s).Useadifferentsheetperproblem. Usephrasestodescribewhatyouaredoing.Donotpresentitasjustaseriesofequationsandnumbers. Labeleachstep.Ex:Step
University of the Philippines Diliman - IE - 151
IE150ProblemSet10CostOnlyAlternativesandIncrementalAnalysisInstructions: Write/Type/Printyouranswersonyellowpadorbondpaper(NOA4s).Useadifferentsheetperproblem. Usephrasestodescribewhatyouaredoing.Donotpresentitasjustaseriesofequationsandnumbers. La
University of the Philippines Diliman - IE - 151
IE150ProblemSet11DifferentUsefulLivesRepeatabilityInstructions: Write/Type/Printyouranswersonyellowpadorbondpaper(NOA4s).Useadifferentsheetperlongproblem. Usephrasestodescribewhatyouaredoing.Donotpresentitasjustaseriesofequationsandnumbers. Labelea
University of the Philippines Diliman - IE - 151
IE150ProblemSet12DifferentUsefulLivesCoterminatedInstructions: Write/Type/Printyouranswersonyellowpadorbondpaper(NOA4s).Useadifferentsheetperlongproblem. Usephrasestodescribewhatyouaredoing.Donotpresentitasjustaseriesofequationsandnumbers. Labeleac
University of the Philippines Diliman - IE - 151
IE150ProblemSet13DepreciationandIncomeTaxesInstructions: Write/Type/Printyouranswersonyellowpadorbondpaper(NOA4s).Useadifferentsheetperproblem. Usephrasestodescribewhatyouaredoing.Donotpresentitasjustaseriesofequationsandnumbers. Labeleachstep.Ex:S
University of the Philippines Diliman - IE - 151
IE150ProblemSet14ReplacementAnalysiswithoutTaxes(SameUL)Instructions: Write/Type/Printyouranswersonyellowpadorbondpaper(NOA4s).Useadifferentsheetperproblem. Usephrasestodescribewhatyouaredoing.Donotpresentitasjustaseriesofequationsandnumbers. Label
University of the Philippines Diliman - IE - 151
IE150ProblemSet15ReplacementAnalysiswithoutTaxes(DiffUL)Instructions: Write/Type/Printyouranswersonyellowpadorbondpaper(NOA4s).Useadifferentsheetperproblem. Usephrasestodescribewhatyouaredoing.Donotpresentitasjustaseriesofequationsandnumbers. Label
University of the Philippines Diliman - IE - 151
IE150ProblemSet16RiskandUncertaintyInstructions: Write/Type/Printyouranswersonyellowpadorbondpaper(NOA4s).Useadifferentsheetperproblem. Usephrasestodescribewhatyouaredoing.Donotpresentitasjustaseriesofequationsandnumbers. Labeleachstep.Ex:Step1:Set
University of the Philippines Diliman - IE - 151
IE150ProblemSet17SensitivityAnalysisInstructions: Write/Type/Printyouranswersonyellowpadorbondpaper(NOA4s).Useadifferentsheetperproblem. Usephrasestodescribewhatyouaredoing.Donotpresentitasjustaseriesofequationsandnumbers. Labeleachstep.Ex:Step1:Se
University of the Philippines Diliman - IE - 151
IE150ProblemSet18PayoffMatricesInstructions: Write/Type/Printyouranswersonyellowpadorbondpaper(NOA4s).Useadifferentsheetperproblem. Usephrasestodescribewhatyouaredoing.Donotpresentitasjustaseriesofequationsandnumbers. Labeleachstep.Ex:Step1:Setupth
University of the Philippines Diliman - IE - 151
IE150ProblemSet19DecisionTreesInstructions: Write/Type/Printyouranswersonyellowpadorbondpaper(NOA4s).Useadifferentsheetperproblem. Usephrasestodescribewhatyouaredoing.Donotpresentitasjustaseriesofequationsandnumbers. Labeleachstep.Ex:Step1:Setupthe
University of the Philippines Diliman - IE - 151
IE150ProblemSet20ExpectedValueofPerfectInformationInstructions: Write/Type/Printyouranswersonyellowpadorbondpaper(NOA4s).Useadifferentsheetperproblem. Usephrasestodescribewhatyouaredoing.Donotpresentitasjustaseriesofequationsandnumbers. Labeleachst
UNSW - ACCT - 2542
TUTORIAL 5 SOLUTIONSAccounting for Income TaxPicker Problem 8.5 Oakley LtdChange in tax rateAdjusting journal entry:Dr. Deferred Tax Liability18 200Cr. Deferred Tax AssetCr. Income Tax Expense(being recognition of change of tax rate)7 40010 800
UNSW - ACCT - 2542
TUTORIAL 6 SOLUTIONSProblem 12.1Accounting for a business combination by both the acquirer and theacquireeELIZABETH LTD FRENCH LTDA(1)Assuming the fair value of A ordinary shares was $2 per shareAcquisition analysisNet fair value of identifiable a