Mastering WGU D326 – Advanced Data Management

Navigating WGU D326 – Advanced Data Management is a pivotal step for students in IT or Computer Science programs at Western Governors University. This SEO-optimized guide, packed with “WGU D326 tips,” insights on “how to pass WGU D326,” and real student experiences from “WGU D326 Reddit” discussions, will help you conquer this course. Whether you’re tackling SQL queries or stored procedures, we’ve compiled strategies to succeed.

Course Description

WGU D326 – Advanced Data Management builds on foundational database skills, focusing on advanced SQL techniques. The course covers ETL workflows, user-defined functions, triggers, and stored procedures, using a PostgreSQL database (often a DVD rental dataset). It’s essential for IT professionals to master data manipulation and automation, skills critical for database administration and analytics roles. For more details, visit the WGU Computer Science program guide.

[](https://www.studocu.com/en-us/document/western-governors-university/advanced-data-management/d326-course-guide/74625076)[](https://www.studocu.com/en-us/document/western-governors-university/business-of-it-applications/d326-course-guide-111/93872539)

Useful Resources & Tips

Students on Reddit and forums recommend these resources for WGU D326:

  • WGU Course Materials: The “Performance Assessment Information” video in the announcements is crucial—watch it at 2x speed for clarity.
  • PostgreSQL Tutorial: Postgresqltutorial.com offers guides on syntax, joins, and database setup, ideal for local practice.
  • Studocu: Access D326 course guides and student notes for project structure.
  • YouTube: Videos on stored procedures and triggers, like those from WGU cohorts or tech channels, clarify complex concepts.
  • Quizlet: Flashcards for SQL syntax and PostgreSQL-specific terms.

Tips: Use the PgAdmin virtual environment efficiently, as it’s on a timer. Create separate query tabs for each task (B-F) and label them clearly. Practice SQL queries locally to avoid VM issues.

[](https://www.reddit.com/r/WGU/comments/1b4sgzj/fast_pass_on_advanced_data_management_d326/)[](https://www.reddit.com/r/WGU/comments/1c2pnb5/d326_advanced_data_management_tips_and_suggestions/)[](https://www.reddit.com/r/WGU/comments/1d7an5w/d326_advanced_data_management/)

Mode of Assessment

WGU D326 is evaluated through a Performance Assessment (PA), requiring two deliverables: a written document outlining a business problem (e.g., DVD rental analytics) with SQL solutions, and a Panopto video explaining your code in the PgAdmin environment.

[](https://www.reddit.com/r/WGU/comments/1b4sgzj/fast_pass_on_advanced_data_management_d326/)[](https://blog.rickp.dev/%25E2%259C%2585-passed-advanced-data-management-d326/)

Common Challenges

Based on “WGU D326 Reddit” posts and forums, students face these hurdles:

  • Complex Business Problem: Choosing an overly complicated business case leads to multiple revisions.
  • Virtual Environment Issues: The PgAdmin VM’s timer and data wipes frustrate students if not managed properly.
  • Stored Procedures and Triggers: Writing and automating these SQL features is new and challenging for many.
  • Video Requirement: Recording a clear Panopto video while explaining code can be daunting, especially for those camera-shy.
  • Rubric Missteps: Missing rubric details (e.g., verifying data or job scheduling tools) leads to resubmissions.

    [](https://www.reddit.com/r/WGU/comments/16do510/d326_advanced_data_management/)[](https://www.reddit.com/r/WGU/comments/17nkea3/d326_advanced_data_management_very_quick_question/)[](https://www.reddit.com/r/WGU/comments/1ec0ic6/a_warning_and_review_for_d326_advanced_data/)

How to Pass Easily

To ace WGU D326 on your first submission, follow these student-tested strategies from Reddit and forums:

  1. Simplify the Business Case: Choose a straightforward problem (e.g., DVD rental sales analysis) to avoid overcomplication, as advised on Reddit.
  2. [](https://www.reddit.com/r/WGU_CompSci/comments/168bbqr/month_two_recap_tips_for_d426_d427_d326_d197_d286/)

  3. Use CREATE TABLE AS: For Part C, reuse your Part D SELECT statement to define tables, saving time on column names and data types.
  4. [](https://www.reddit.com/r/WGU/comments/1c2pnb5/d326_advanced_data_management_tips_and_suggestions/)[](https://www.reddit.com/r/WGU_CompSci/comments/1ccw3qx/d326_advanced_data_management_assessment/)

  5. Watch Key Videos: The cohort videos on functions, stored procedures, and triggers are gold—watch them multiple times.
  6. [](https://www.reddit.com/r/WGU/comments/1c2pnb5/d326_advanced_data_management_tips_and_suggestions/)[](https://www.reddit.com/r/WGU/comments/1ap29at/d326_advanced_data_management/)

  7. Organize Code: In PgAdmin, create labeled query tabs (B-F) and include SELECT statements to verify functionality.
  8. [](https://www.reddit.com/r/WGU_CompSci/comments/1ccw3qx/d326_advanced_data_management_assessment/)

  9. Practice Video Delivery: Rehearse your Panopto script to explain code clearly, focusing on SQL logic and outcomes.
  10. Check Rubric Thoroughly: Review the rubric and “common mistakes” document to avoid pitfalls like missing data verification.
  11. [](https://www.reddit.com/r/WGU/comments/1b4sgzj/fast_pass_on_advanced_data_management_d326/)[](https://www.reddit.com/r/WGU_CompSci/comments/177thdc/d326_advanced_data_management/)

  12. Timeframe: Dedicate 1-2 weeks, with 2-3 hours daily. Many passed in 2-7 days with prior SQL knowledge.
  13. [](https://www.reddit.com/r/WGU_CompSci/comments/1crzmif/d326_advanced_data_management_passed_in_2/)[](https://www.reddit.com/r/WGU/comments/1ap29at/d326_advanced_data_management/)

Conclusion

WGU D326 – Advanced Data Management may seem intimidating, but with the right approach, you can master it. By leveraging “WGU D326 tips” from Reddit, focusing on key videos, and organizing your SQL work, you’ll pass the PA confidently. Start early, simplify your project, and dive in! For more guides, see all WGU course guides here.

FAQ

Is WGU D326 hard?

WGU D326 can be challenging due to advanced SQL concepts like stored procedures and triggers, plus the video requirement. However, with prior SQL knowledge from D426/D427 and focused prep, students find it manageable.

[](https://www.reddit.com/r/WGU/comments/1ec0ic6/a_warning_and_review_for_d326_advanced_data/)[](https://blog.rickp.dev/%25E2%259C%2585-passed-advanced-data-management-d326/)

How long does WGU D326 take?

Most students complete WGU D326 in 1-2 weeks with 2-3 hours daily. Those with strong SQL skills have passed in 2-7 days.

[](https://www.reddit.com/r/WGU_CompSci/comments/1crzmif/d326_advanced_data_management_passed_in_2/)[](https://www.reddit.com/r/WGU/comments/1ap29at/d326_advanced_data_management/)

Is WGU D326 an OA or PA?

WGU D326 is a Performance Assessment (PA), requiring a written report and a Panopto video explaining your SQL code in PgAdmin.

[](https://www.reddit.com/r/WGU/comments/1b4sgzj/fast_pass_on_advanced_data_management_d326/)

What are the key topics on the exam?

The PA focuses on ETL workflows, user-defined functions, triggers, stored procedures, and job scheduling tools, applied to a business problem like DVD rental analytics.

[](https://www.studocu.com/en-us/document/western-governors-university/business-of-it-applications/d326-course-guide-111/93872539)

What’s the best way to study for WGU D326?

The best way to study for WGU D326 is to watch cohort videos, use Postgresqltutorial.com, organize query tabs in PgAdmin, and practice your video explanation, as shared in “WGU D326 Reddit” tips.

[](https://www.reddit.com/r/WGU/comments/1c2pnb5/d326_advanced_data_management_tips_and_suggestions/)[](https://www.reddit.com/r/WGU/comments/1d7an5w/d326_advanced_data_management/)

🎓 Stressed About This Exam? You're Not Alone. But We've Got the Solution!

Failing attempts? Confusing materials? Overwhelming pressure?

We help you pass this exam on the FIRST TRY, no matter the platform or proctoring software.

  • Real-time assistance
  • 100% confidential
  • No upfront payment—pay only after success!

📌 Don’t struggle alone. Join the students who are passing stress-free!

👉 Book your exam appointment today and never get stuck with an exam again.

🎯 Your success is just one click away!

Question 1

After the success of the company?s first two months, Santana Rey continues to operate Business Solutions. The November 30, 2011, unadjusted trial balance of Business Solutions (reflecting its transactions for October and November of 2011) follows. No. Account Title Debit Credit 101 Cash $ 38,664 106 Accounts receivable 13,418 126 Computer supplies 2,645 128 Prepaid insurance 2,100 131 Prepaid rent 3,240 163 Office equipment 8,800 164 Accumulated depreciation?Office equipment $ 0 167 Computer equipment 21,200 168 Accumulated depreciation?Computer equipment 0 201 Accounts payable 0 210 Wages payable 0 236 Unearned computer services revenue 0 301 Common stock 63,000 Retained earnings 0 302 Dividends 5,700 403 Computer services revenue 38,524 612 Depreciation expense?Office equipment 0 613 Depreciation expense?Computer equipment 0 623 Wages expense 2,550 637 Insurance expense 0 640 Rent expense 0 652 Computer supplies expense 0 655 Advertising expense 1,638 676 Mileage expense 624 677 Miscellaneous expenses 180 684 Repairs expense?Computer 765 Totals $ 101,524 $ 101,524 Business Solutions had the following transactions and events in December 2011. Dec. 2 Paid $1,025 cash to Hillside Mall for Business Solutions? share of mall advertising costs. 3 Paid $450 cash for minor repairs to the company?s computer. 4 Received $4,850 cash from Alex?s Engineering Co. for the receivable from November. 10 Paid cash to Lyn Addie for six days of work at the rate of $110 per day. 14 Notified by Alex's Engineering Co. that Business Solutions? bid of $7,300 on a proposed project has been accepted. Alex?s paid a $2,500 cash advance to Business Solutions. 15 Purchased $1,900 of computer supplies on credit from Harris Office Products. 16 Sent a reminder to Gomez Co. to pay the fee for services recorded on November 8. 20 Completed a project for Liu Corporation and received $6,075 cash. 22?26 Took the week off for the holidays. 28 Received $3,500 cash from Gomez Co. on its receivable. 29 Reimbursed S. Rey for business automobile mileage (400 miles at $0.23 per mile). 31 The business paid $1,100 cash for dividends. The following additional facts are collected for use in making adjusting entries prior to preparing financial statements for the company's first three months: a. The December 31 inventory count of computer supplies shows $670 still available. b. Three months have expired since the 12-month insurance premium was paid in advance. c. As of December 31, Lyn Addie has not been paid for four days of work at $110 per day. d. The company's computer is expected to have a four-year life with no salvage value. e. The office equipment is expected to have a five-year life with no salvage value. f. Three of the four months' prepaid rent has expired. 3. Prepare an adjusted trial balance as of December 31, 2011. (The items in the Trial Balance should be grouped as follows: Assets and Liabilities (in order of their liquidity) then Equity, Revenues, and Expenses. Leave no cells blank - be certain to enter "0" wherever required. Omit the "$" sign in your response.) BUSINESS SOLUTIONS Adjusted Trial Balance December 31, 2011 Debit Credit $ $ Totals $ $ 4. Prepare an income statement for the three months ended December 31, 2011. (Input all amounts as positive values. Omit the "$" sign in your response.) BUSINESS SOLUTIONS Income Statement For Three Months Ended December 31, 2011 Debit Credit Revenue $ Expenses $ Total expenses $ 5. Prepare a statement of owner?s equity for the three months ended December 31, 2011. (Input all amounts as positive values. Omit the "$" sign in your response.) BUSINESS SOLUTIONS Statement of Owner's Equity For Three Months Ended December 31, 2011 $ $ 6. Prepare a balance sheet as of December 31, 2011. (Be sure to list the assets and liabilities in order of their liquidity. Amounts to be deducted should be indicated with minus sign. Omit the "$" sign in your response.) BUSINESS SOLUTIONS Balance Sheet December 31, 2011 Assets $ $ Total Assets $ Liabilities $ Total Liabilities Equity Total equity Total Liabilities and Equity $ 7. Record and post the necessary closing entries for Business Solutions. (Omit the "$" sign in your response.) Date General Journal Debit Credit Dec. 31, 2011 Dec. 31, 2011 Dec. 31, 2011 Dec. 31, 2011 8. Prepare a post-closing trial balance as of December 31, 2011. (The items in the Trial Balance should be grouped as follows: Assets and Liabilities (in order of their liquidity) then Equity, Revenues, and Expenses. Leave no cells blank - be certain to enter "0" wherever required. Omit the "$" sign in your response.) BUSINESS SOLUTIONS Post-Closing Trial Balance December 31, 2011 Debit Credit $ $ Totals $ $

Question 2

MAT540 Week 7 Homework Chapter 3 8. Solve the model formulated in Problem 7 for Southern Sporting Goods Company using the computer. a. State the optimal solution. b. What would be the effect on the optimal solution if the profit for a basketball changed from $12 to $13? What would be the effect if the profit for a football changed from $16 to $15? c. What would be the effect on the optimal solution if 500 additional pounds of rubber could be obtained? What would be the effect if 500 additional square feet of leather could be obtained? Reference Problem 7. Southern Sporting Good Company makes basketballs and footballs. Each product is produced from two resources rubber and leather. The resource requirements for each product and the total resources available are as follows: Resource Requirements per Unit Product Rubber (lb.) Leather (ft2) Basketball 3 4 Football 2 5 Total resources available 500 lb. 800 ft2 10. A company produces two products, A and B, which have profits of $9 and $7, respectively. Each unit of product must be processed on two assembly lines, where the required production times are as follows: Hours/ Unit Product Line 1 Line2 A 12 4 B 4 8 Total Hours 60 40 a. Formulate a linear programming model to determine the optimal product mix that will maximize profit. b. Transform this model into standard form. 11. Solve problem 10 using the computer. a. State the optimal solution. b. What would be the effect on the optimal solution if the production time on line 1 was reduced to 40 hours? c. What would be the effect on the optimal solution if the profit for product B was increased from $7 to $15 to $20? 12. For the linear programming model formulated in Problem 10 and solved in Problem 11. a. What are the sensitivity ranges for the objective function coefficients? b. Determine the shadow prices for additional hours of production time on line 1 and line 2 and indicate whether the company would prefer additional line 1 or line 2 hours. 14. Solve the model formulated in Problem 13 for Irwin Textile Mills. a. How much extra cotton and processing time are left over at the optimal solution? Is the demand for corduroy met? b. What is the effect on the optimal solution if the profit per yard of denim is increased from $2.25 to $3.00? What is the effect if the profit per yard of corduroy is increased from $3.10 to $4.00? c. What would be the effect on the optimal solution if Irwin Mils could obtain only 6,000 pounds of cotton per month? Reference Problem 13. Irwin Textile Mills produces two types of cotton cloth ? denim and corduroy. Corduroy is a heavier grade of cotton cloth and, as such, requires 7.5 pounds of raw cotton per yard, whereas denim requires 5 pounds of raw cotton per yard. A yard of corduroy requires 3.2 hours of processing time; a yard of denim requires 3.0 hours. Although the demand for denim is practically unlimited, the maximum demand for corduroy is 510 yards per month. The manufacturer has 6,500 pounds of cotton and 3,000 hours of processing time available each month. The manufacturer makes a profit of $2.25 per yard of denim and $3.10 per yard of corduroy. The manufacturer wants to know how many yards of each type of cloth to produce to maximize profit. Formulate the model and put it into standard form. Solve it. 15. Continuing the model from Problem 14. a. If Irwin Mills can obtain additional cotton or processing time, but not both, which should it select? How much? Explain your answer. b. Identify the sensitivity ranges for the objective function coefficients and for the constraint quantity values. Then explain the sensitivity range for the demand for corduroy. ? 16. United Aluminum Company of Cincinnati produces three grades (high, medium, and low) of aluminum at two mills. Each mill has a different production capacity (in tons per day) for each grade as follows: Aluminum Grade Mill 1 2 High 6 2 Medium 2 2 Low 4 10 The company has contracted with a manufacturing firm to supply at least 12 tons of high-grade aluminum, and 5 tons of low-grade aluminum. It costs United $6,000 per day to operate mill 1 and $7,000 per day to operate mill 2. The company wants to know the number of days to operate each mill in order to meet the contract at minimum cost. a. Formulate a linear programming model for this problem. 18. Solve the linear programming model formulated in Problem 16 for Unite Aluminum Company by using the computer. a. Identify and explain the shadow prices for each of the aluminum grade contract requirements. b. Identify the sensitivity ranges for the objective function coefficients and the constraint quantity values. c. Would the solution values change if the contract requirements for high-grade alumimum were increased from 12 tons to 20 tons? If yes, what would the new solution values be? 24. Solve the linear programming model developed in Problem 22 for the Burger Doodle restaurant by using the computer. a. Identify and explain the shadow prices for each of the resource constraints b. Which of the resources constrains profit the most? c. Identify the sensitivity ranges for the profit of a sausage biscuit and the amount of sausage available. Explain these sensitivity ranges. Reference Problem 22. The manager of a Burger Doodle franchise wants to determine how many sausage biscuits and ham biscuits to prepare each morning for breakfast customers. The two types of biscuits require the following resources: Biscuit Labor (hr.) Sausage (lb.) Ham (lb.) Flour (lb.) Sausage 0.010 0.10 --- 0.04 Ham 0.024 --- 0.15 0.04 The franchise has 6 hours of labor available each morning. The manager has a contract with a local grocer for 30 pounds of sausage and 30 pounds of ham each morning. The manager also purchases 16 pounds of flour. The profit for a sausage biscuit is $0.60; the profit for a ham biscuit is $0.50. The manager wants to know the number of each type of biscuit to prepare each morning in order to maximize profit. Formulate a linear programming model for this problem.

Question 3

Course Project B Clark Paints: The Production Department has been investigating possible ways to trim total production costs. One possibility currently being examined is to make the paint cans instead of purchasing them. The equipment needed would cost $200,000, with a disposal value of $40,000, and it would be able to produce 5,500,000 cans over the life of the machinery. The Production Department estimates that approximately 1,100,000 cans would be needed for each of the next five years. The company would hire three new employees. These three individuals would be full-time employees, working 2,000 hours per year and earning $12.00 per hour. They would also receive the same benefits as other production employees, 18% of wages, in addition to $2,500 of health benefits. It is estimated that the raw materials will cost 25? per can and that other variable costs would be 5? per can. Since there is currently unused space in the factory, no additional fixed costs would be incurred if this proposal is accepted. It is expected that cans would cost 45? each if purchased from the current supplier. The company's minimum rate of return (hurdle rate) has been determined to be 12% for all new projects, and the current tax rate of 35% is anticipated to remain unchanged. The pricing for a gallon of paint, as well as the number of units sold, will not be affected by this decision. The unit-of-production depreciation method would be used if the new equipment is purchased. Required: 1. Based on the above information and using Excel, calculate the following items for this proposed equipment purchase: Annual cash flows over the expected life of the equipment; Payback period; Annual rate of return; Net present value; and Internal rate of return. 2. Would you recommend the acceptance of this proposal? Why or why not? Prepare a short, double-spaced Word paper elaborating and supporting your answer. i was provided a check answers document to assist. I have attached it.

Question 4

1 FINA521 International Financial Management Mid Term Exam Due Friday 12 November at 6:00 PM 1. Which of the following theories suggests that firms seek to penetrate new markets over time? a. theory of comparative advantage. b. imperfect markets theory. c. product cycle theory. d. none of the above 2. The interest rate in the U.K. is 7%, while the interest rate in the U.S. is 5%. The spot rate for the British pound is $1.50. According to the international Fisher effect (IFE), the British pound should adjust to a new level of: a. $1.47. b. $1.53. c. $1.43. d. $1.57. 3. Assume that the U.S. one-year interest rate is 3% and the one-year interest rate on Australian dollars is 6%. The U.S. expected annual inflation is 5%, while the Australian inflation is expected to be 7%. You have $100,000 to invest for one year and you believe that PPP holds. The spot exchange rate of an Australian dollar is $0.689. What will be the yield on your investment if you invest in the Australian market? a. 6% b. 3% c. 4% d. 2% Hint: (1 + .05)/(1 + .07) * ______ = $_______ ($100,000/A$______) * (1 + _____) = A$___________ 4. Assume that Live Co. has expected cash flows of $200,000 from domestic operations, SF200,000 from Swiss operations, and 150,000 euros from Italian operations at the end of the year. The Swiss franc's value and euro's value are expected to be $.83 and $1.29 respectively, at the end this year. What are the expected dollar cash flows of Live Co? 2 a. $200,000 b. $559,500 c. $582,500 d. $393,500 5. Subsidiary A of Mega Corporation has net inflows in Australian dollars of A$1,000,000, while Subsidiary B has net outflows in Australian dollars of A$1,500,000. The expected exchange rate of the Australian dollar is $.55. What is the net inflow or outflow as measured in U.S. dollars? a. $500,000 outflow. b. $500,000 inflow. c. $275,000 inflow. d. $275,000 outflow. 6. Assume that interest rate parity holds. The U.S. five-year interest rate is 5% annualized, and the Mexican five-year interest rate is 8% annualized. Today's spot rate of the Mexican peso is $.20. What is the approximate five-year forecast of the peso's spot rate if the five-year forward rate is used as a forecast? a. $.131. b. $.226. c. $.262. d. $.140. e. $.174. Hint: (1.05)5/(1.08)5 - 1 = _________ 7. Saller Co. has a subsidiary in Mexico. The expected cash flows in pesos to be received in the future from this subsidiary have not changed since last month, but the valuation of Saller Co. has declined since last month. What could've caused this decline in value? a. A weaker Mexican economy b. Lower Mexican interest rates c. Depreciation of the Mexican peso d. Appreciation of the Mexican peso. 8. A weak home currency may not be a perfect solution to correct a balance of trade deficit because: a. it reduces the prices of imports paid by local companies. b. it increases the prices of exports by local companies. c. it prevents international trade transactions from being prearranged. d. foreign companies may reduce the prices of their products to stay competitive. 3 9. Assume that a bank's bid rate on Swiss francs is $.45 and its ask rate is $.47. Its bid-ask percentage spread is: a. about 4.44%. b. about 4.26%. c. about 4.03%. d. about 4.17%. 10. Assume the following information: You have $1,000,000 to invest: Current spot rate of pound = $1.30 90-day forward rate of pound = $1.28 3-month deposit rate in U.S. = 3% 3-month deposit rate in Great Britain = 4% If you use covered interest arbitrage for a 90-day investment, what will be the amount of U.S. dollars you will have after 90 days? a. $1,024,000. b. $1,030,000. c. $1,040,000. d. $1,034,000. e.none of the above 11.The international Fisher effect (IFE) suggests that: a. a home currency will depreciate if the current home interest rate exceeds the current foreign interest rate. b. a home currency will appreciate if the current home interest rate exceeds the current foreign interest rate. c. a home currency will appreciate if the current home inflation rate exceeds the current foreign inflation rate. d. a home currency will depreciate if the current home inflation rate exceeds the current foreign inflation rate. 12, The value of euro was $1.30 last week. During last week the euro depreciated by 5%. What is the value of euro today? a. $1.365 b. $1.235 c. $1.330 d. $1.30 4 13. Graylon, Inc., based in Washington, exports products to a German firm and will receive payment of ?200,000 in three months. On June 1, the spot rate of the euro was $1.12, and the 3-month forward rate was $1.10. On June 1, Graylon negotiated a forward contract with a bank to sell ?200,000 forward in three months. The spot rate of the euro on September 1 is $1.15. Graylon will receive $____ for the euros. a. 224,000 b. 220,000 c. 200,000 d. 230,000 14. Assume the following information: Current spot rate of New Zealand dollar = $.41 Forecasted spot rate of New Zealand dollar 1 year from now = $.43 One-year forward rate of the New Zealand dollar = $.42 Annual interest rate on New Zealand dollars = 8% Annual interest rate on U.S. dollars = 9% Given the information in this question, the return from covered interest arbitrage by U.S. investors with $500,000 to invest is ____%. a. about 11.97 b. about 9.63 c. about 11.12 d. about 11.64 e. about 10.63 Hint: $500,000/$.41 = NZ$_______ ? (1.08) = NZ$________ ? _______ = ___________ Yield = 15. Assume that the U.S. one-year interest rate is 3% and the one-year interest rate on Australian dollars is 6%. The U.S. expected annual inflation is 5%, while the Australian inflation is expected to be 7%. You have $100,000 to invest for one year and you believe that PPP holds. The spot exchange rate of an Australian dollar is $0.689. What will be the yield on your investment if you invest in the Australian market? a. 6% b. 3% c. 4% d. 2% Hint: (1 + .05)/(1 + .07) ? $0.689 = $0.676. ($100,000/________) ? (1 + .06) = A$_______ ? $_______ = $________ 5 16. You just received a gift from a friend consisting of 1,000 Thai baht, which you would like to exchange for Australian dollars (A$). You observe that exchange rate quotes for the baht are currently $.023, while quotes for the Australian dollar are $.576. How many Australian dollars should you expect to receive for your baht? a. A$39.93. b. A$25,043.48. c. A$553.00. d. none of the above 17. Assume that the inflation rate in Singapore is 3%, while the inflation rate in the U.S. is 8%. According to PPP, the Singapore dollar should ____ by ____%. a. appreciate; 4.85 b. depreciate; 3,11 c. appreciate; 3.11 d. depreciate; 4.85 18. The one-year forward rate of the British pound is quoted at $1.60, and the spot rate of the British pound is quoted at $1.63. The forward ____ is ____ percent. a. discount; 1.9 b. discount; 1.8 c. premium; 1.9 d. premium; 1.8 19 .If a U.S. firm desires to avoid the risk from exchange rate fluctuations, and it is receiving 100,000 in 90 days, it could: a. obtain a 90-day forward purchase contract on euros. b. obtain a 90-day forward sale contract on euros. c. purchase euros 90 days from now at the spot rate. d. sell euros 90 days from now at the spot rate. 6 20. Assume the Canadian dollar is equal to $.88 and the Peruvian Sol is equal to $.35. The value of the Peruvian Sol in Canadian dollars is: a. about .3621 Canadian dollars. b. about .3977 Canadian dollars. c. about 2.36 Canadian dollars. d. about 2.51 Canadian dollars. 21. A forward contract can be used to lock in the ____ of a specified currency for a future point in time. a. purchase price b. sale price c. A or B d. none of the above 22. A Japanese yen is worth $.0080, and a Fijian dollar (F$) is worth $.5900. What is the value of the yen in Fijian dollars (i.e., how many Fijian dollars do you need to buy a yen)? a. 73.75. b. 125. c. 1.69. d. 0.014. e. none of the above 23. Assume the bid rate of an Australian dollar is $.60 while the ask rate is $.61 at Bank Q. Assume the bid rate of an Australian dollar is $.62 while the ask rate is $.625 at Bank V. Given this information, what would be your gain if you use $1,000,000 and execute locational arbitrage? That is, how much will you end up with over and above the $1,000,000 you started with? 7 a. $10,003. b. $12,063. c. $14,441. d. $16,393. e. $18,219. 24.Assume the following information: Current spot rate of New Zealand dollar = $.41 Forecasted spot rate of New Zealand dollar 1 year from now = $.43 One-year forward rate of the New Zealand dollar = $.42 Annual interest rate on New Zealand dollars = 8% Annual interest rate on U.S. dollars = 9% Given the information in this question, the return from covered interest arbitrage by U.S. investors with $500,000 to invest is ____%. a. about 11.97 b. about 9.63 c. about 11.12 d. about 11.64 e. about 10.63 Hint: $500,000/$.41 = NZ$1,219,512 ? (1.08) = NZ$1,317,073 ? .42 = ________ Yield = ( ________ ? $500,000)/$500,000 = ___________ 25. Cerra Co. expects to receive 5 million euros tomorrow as a result of selling goods to the Netherlands. Cerra estimates the standard deviation of daily percentage changes of the euro to be 1 percent over the last 100 days. Assume that these percentage changes are normally distributed. Use the value-at-risk (VAR) method based on a 95% confidence level for the following question(s). What is the maximum one-day loss if the expected percentage change of the euro tomorrow is 0.5%? a. -0.5% b. -2.2% c. -1.5% d. -1.2% 26.According to interest rate parity (IRP): a. the forward rate differs from the spot rate by a sufficient amount to offset the inflation differential between two currencies. 8 b. the future spot rate differs from the current spot rate by a sufficient amount to offset the interest rate differential between two currencies. c. the future spot rate differs from the current spot rate by a sufficient amount to offset the inflation differential between two currencies. d. the forward rate differs from the spot rate by a sufficient amount to offset the interest rate differential between two currencies. 27. Assume that the interest rate offered on pounds is 5% and the pound is expected to depreciate by 1.5%. For the international Fisher effect (IFE) to hold between the U.K. and the U.S., the U.S. interest rate should be ____. a. 3.43% b. 5.68% c. 6.5% d. 7.3% 28. If a U.S. firm desires to avoid the risk from exchange rate fluctuations, and it will need C$200,000 in 90 days to make payment on imports from Canada, it could: a. obtain a 90-day forward purchase contract on Canadian dollars. b. obtain a 90-day forward sale contract on Canadian dollars. c. purchase Canadian dollars 90 days from now at the spot rate. d. sell Canadian dollars 90 days from now at the spot rate. 29. Assume the following information: Quoted Bid Price Quoted Ask Price Value of an Australian dollar (A$) in $ $0.67 $0.69 Value of Mexican peso in $ $.074 $.077 Value of an Australian dollar in Mexican pesos 8.2 8.5 Assume you have $100,000 to conduct triangular arbitrage. What will be your profit from implementing this strategy? a. $6,133 b. $2,368 9 c. $6,518 d. $13,711 30. Livingston Co. has a subsidiary in Korea. The subsidiary reinvests half of its net cash flows into operations and remits half to the parent. Livingston's expected cash flows from domestic business are $100,000 and the Korean subsidiary is expected to generate 100 million Korean won at the end of the year. The expected value of won is $.0012. What are the expected dollar cash flows of Livingston Co.? a. $100,000 b. $200,000 c. $160,000 d. $60,000 31. If the Fed desires to weaken the dollar without affecting the dollar money supply, it should: a. exchange dollars for foreign currencies, and sell some of its existing Treasury security holdings for dollars. b. exchange foreign currencies for dollars, and sell some of its existing Treasury security holdings for dollars. c. exchange dollars for foreign currencies, and buy existing Treasury securities with dollars. d. exchange foreign currencies for dollars, and buy existing Treasury securities with dollars. 32. A U.S. corporation has purchased currency call options to hedge a 70,000 pound payable. The premium is $.02 and the exercise price of the option is $.50. If the spot rate at the time of maturity is $.65, what is the total amount paid by the corporation if it acts rationally? a. $33,600. b. $46,900. c. $44,100. d. $36,400. Hint: Dollars paid when exercising the option = ?________ ? $.50 = $35,000. Premium paid for options = ?70,000 ? $.02 = Amount of dollars paid = ____________ 33. Jensen Co. expects to pay ?50,000 in one month for its imports from France. It also expects to receive ?200,000 for its exports to Belgium in one month. Jensen estimates the standard 10 deviation of monthly percentage changes of the euro to be 2.5 percent over the last 50 months. Assume that these percentage changes are normally distributed. Using the value-at-risk (VAR) method based on a 97.5% confidence level, what is the maximum one month loss in dollars if the expected percentage change of the euro during next month is 2%? Assume that current spot rate of the euro (before considering the maximum one-month loss) is $1.35. a. -$4,303 b. -$7,830 c. -$5,873 d. -$1,958 Hint: Net exposure = ?200,000 - ?50,000 = ?150,000 34. Assume that the inflation rate becomes much higher in the U.K. relative to the U.S. This will place ____ pressure on the value of the British pound. Also, assume that interest rates in the U.K. begin to rise relative to interest rates in the U.S. The change in interest rates will place ____ pressure on the value of the British pound. a. upward; downward b. upward; upward c. downward; upward d. downward; downward 35. Any event that increases the supply of British pounds to be exchanged for U.S. dollars should result in a(n) ____ in the value of the British pound with respect to ____, other things being equal. a. increase; U.S. dollar b. increase; nondollar currencies c. decrease; nondollar currencies d. decrease; U.S. dollar 36.Baylor Bank believes the New Zealand dollar will appreciate over the next five days from $.48 to $.50. The following annual interest rates apply: Currency Lending Rate Borrowing Rate Dollars 7.10% 7.50% New Zealand dollar (NZ$) 6.80% 7.25% Baylor Bank has the capacity to borrow either NZ$10 million or $5 million. If Baylor Bank's forecast is correct, what will its dollar profit be from speculation over the five-day period (assuming it does not use any of its existing consumer deposits to capitalize on its expectations)? a. $521,325. b. $500,520. 11 c. $104,262. d. $413,419. e. $208,044. Hint: 1. Borrow $5 million. 2. Convert to NZ$: $5,000,000/$.48 = NZ$ __________ 3. Invest the NZ$ at an annualized rate of 6.80% over five days. NZ$________ * [1 + 6.80% (5/360)] 4. Convert the NZ$ back to dollars: 5. Repay the dollars borrowed. 6. After repaying the loan, the remaining dollar profit is: 37.A firm wants to use an option to hedge 12.5 million in receivables from New Zealand firms. The premium is $.03. The exercise price is $.55. If the option is exercised, what is the total amount of dollars received (after accounting for the premium paid)? a. $6,875,000. b. $7,250,000. c. $7,000,000. d. $6,500,000. e. none of the above 38. The premium on a pound put option is $.03 per unit. The exercise price is $1.60. The break-even point is ____ for the buyer of the put, and ____ for the seller of the put. (Assume zero transactions costs and that the buyer and seller of the put option are speculators.) a. $1.63; $1.63 b. $1.63; $1.60 c. $1.63; $1.57 d. $1.57; $1.63 e. none of the above 12 39. Carl is an option writer. In anticipation of a depreciation of the British pound from its current level of $1.50 to $1.45, he has written a call option with an exercise price of $1.51 and a premium of $.02. If the spot rate at the option's maturity turns out to be $1.54, what is Carl's profit or loss per unit (assuming the buyer of the option acts rationally)? a. -$0.01. b. $0.01. c. -$0.04. d. $0.04. e. -$0.03. 40.Your company expects to receive 5,000,000 Japanese yen 60 days from now. You decide to hedge your position by selling Japanese yen forward. The current spot rate of the yen is $.0089, while the forward rate is $.0095. You expect the spot rate in 60 days to be $.0090. How many dollars will you receive for the 5,000,000 yen 60 days from now? a. $44,500. b. $45,000. c. $526 million. d. $47,500. 41. The inflation rate in the U.S. is 4%, while the inflation rate in Japan is 1.5%. The current exchange rate for the Japanese yen (?) is $0.0080. After supply and demand for the Japanese yen has adjusted according to purchasing power parity, the new exchange rate for the yen will be a. $0.0078. b. $0.0082. c. $0.0111. d. $0.00492. e. None of the above 42. The premium on a euro call option is $.02. The exercise price is $1.32. The break-even point is ____ for the buyer of the call, and ____ for the seller of the call. (Assume zero transactions costs and that the 13 buyer and seller of the put option are speculators.) a. $1.30; $1.30 b. $1.34; $1.30 c. $1.30; $1.34 d. $1.34; $1.34 43. Dubas Co. is a U.S.-based MNC that has a subsidiary in Germany and another subsidiary in Greece. Both subsidiaries frequently remit their earnings back to the parent company. The German subsidiary generated a net outflow of ?2,000,000 this year, while the Greek subsidiary generated a net inflow of ?1,500,000. What is the net inflow or outflow as measured in U.S. dollars this year? The exchange rate for the euro is $1.05. a. $3,675,000 outflow b. $525,000 outflow c. $525,000 inflow d. $210,000 outflow 44.A strong dollar is normally expected to cause: a. high unemployment and high inflation in the U.S. b. high unemployment and low inflation in the U.S. c. low unemployment and low inflation in the U.S. d. low unemployment and high inflation in the U.S. 45. It has been argued that the exchange rate can be used as a policy tool. Assume that the U.S. government would like to reduce inflation. Which of the following is an appropriate action given this scenario? a. Sell dollars for foreign currency b. Buy dollars with foreign currency c. Lower interest rates d. None of the above 46.Assume that interest rate parity holds. The U.S. five-year interest rate is 5% annualized, and the Mexican five-year interest rate is 8% annualized. Today's spot rate of the Mexican peso is $.20. What is the approximate five-year forecast of the peso's spot rate if the five-year forward rate is used as a forecast? a. $.131. b. $.226. 14 c. $.262. d. $.140. e. $.174. 47. A weak dollar is normally expected to cause: a. high unemployment and high inflation in the U.S. b. high unemployment and low inflation in the U.S. c. low unemployment and low inflation in the U.S. d. low unemployment and high inflation in the U.S. 48. Your company expects to receive 5,000,000 Japanese yen 60 days from now. You decide to hedge your position by selling Japanese yen forward. The current spot rate of the yen is $.0089, while the forward rate is $.0095. You expect the spot rate in 60 days to be $.0090. How many dollars will you receive for the 5,000,000 yen 60 days from now if you sell yen forward? a. $44,500 b. $45,000 c. $526 million d. $47,500 e. $556 million 49. Assume U.S. and Swiss investors require a real rate of return of 3%. Assume the nominal U.S. interest rate is 6% and the nominal Swiss rate is 4%. According to the international Fisher effect, the franc will ____ by about ____. a. appreciate; 3% b. appreciate; 1% c. depreciate; 3% d. depreciate; 2% e. appreciate; 2%,1 FINA521 International Financial Management Mid Term Exam Due Friday 12 November at 6:00 PM 1. Which of the following theories suggests that firms seek to penetrate new markets over time? a. theory of comparative advantage. b. imperfect markets theory. c. product cycle theory. d. none of the above 2. The interest rate in the U.K. is 7%, while the interest rate in the U.S. is 5%. The spot rate for the British pound is $1.50. According to the international Fisher effect (IFE), the British pound should adjust to a new level of: a. $1.47. b. $1.53. c. $1.43. d. $1.57. 3. Assume that the U.S. one-year interest rate is 3% and the one-year interest rate on Australian dollars is 6%. The U.S. expected annual inflation is 5%, while the Australian inflation is expected to be 7%. You have $100,000 to invest for one year and you believe that PPP holds. The spot exchange rate of an Australian dollar is $0.689. What will be the yield on your investment if you invest in the Australian market? a. 6% b. 3% c. 4% d. 2% Hint: (1 + .05)/(1 + .07) * ______ = $_______ ($100,000/A$______) * (1 + _____) = A$___________ 4. Assume that Live Co. has expected cash flows of $200,000 from domestic operations, SF200,000 from Swiss operations, and 150,000 euros from Italian operations at the end of the year. The Swiss franc's value and euro's value are expected to be $.83 and $1.29 respectively, at the end this year. What are the expected dollar cash flows of Live Co? 2 a. $200,000 b. $559,500 c. $582,500 d. $393,500 5. Subsidiary A of Mega Corporation has net inflows in Australian dollars of A$1,000,000, while Subsidiary B has net outflows in Australian dollars of A$1,500,000. The expected exchange rate of the Australian dollar is $.55. What is the net inflow or outflow as measured in U.S. dollars? a. $500,000 outflow. b. $500,000 inflow. c. $275,000 inflow. d. $275,000 outflow. 6. Assume that interest rate parity holds. The U.S. five-year interest rate is 5% annualized, and the Mexican five-year interest rate is 8% annualized. Today's spot rate of the Mexican peso is $.20. What is the approximate five-year forecast of the peso's spot rate if the five-year forward rate is used as a forecast? a. $.131. b. $.226. c. $.262. d. $.140. e. $.174. Hint: (1.05)5/(1.08)5 - 1 = _________ 7. Saller Co. has a subsidiary in Mexico. The expected cash flows in pesos to be received in the future from this subsidiary have not changed since last month, but the valuation of Saller Co. has declined since last month. What could've caused this decline in value? a. A weaker Mexican economy b. Lower Mexican interest rates c. Depreciation of the Mexican peso d. Appreciation of the Mexican peso. 8. A weak home currency may not be a perfect solution to correct a balance of trade deficit because: a. it reduces the prices of imports paid by local companies. b. it increases the prices of exports by local companies. c. it prevents international trade transactions from being prearranged. d. foreign companies may reduce the prices of their products to stay competitive. 3 9. Assume that a bank's bid rate on Swiss francs is $.45 and its ask rate is $.47. Its bid-ask percentage spread is: a. about 4.44%. b. about 4.26%. c. about 4.03%. d. about 4.17%. 10. Assume the following information: You have $1,000,000 to invest: Current spot rate of pound = $1.30 90-day forward rate of pound = $1.28 3-month deposit rate in U.S. = 3% 3-month deposit rate in Great Britain = 4% If you use covered interest arbitrage for a 90-day investment, what will be the amount of U.S. dollars you will have after 90 days? a. $1,024,000. b. $1,030,000. c. $1,040,000. d. $1,034,000. e.none of the above 11.The international Fisher effect (IFE) suggests that: a. a home currency will depreciate if the current home interest rate exceeds the current foreign interest rate. b. a home currency will appreciate if the current home interest rate exceeds the current foreign interest rate. c. a home currency will appreciate if the current home inflation rate exceeds the current foreign inflation rate. d. a home currency will depreciate if the current home inflation rate exceeds the current foreign inflation rate. 12, The value of euro was $1.30 last week. During last week the euro depreciated by 5%. What is the value of euro today? a. $1.365 b. $1.235 c. $1.330 d. $1.30 4 13. Graylon, Inc., based in Washington, exports products to a German firm and will receive payment of ?200,000 in three months. On June 1, the spot rate of the euro was $1.12, and the 3-month forward rate was $1.10. On June 1, Graylon negotiated a forward contract with a bank to sell ?200,000 forward in three months. The spot rate of the euro on September 1 is $1.15. Graylon will receive $____ for the euros. a. 224,000 b. 220,000 c. 200,000 d. 230,000 14. Assume the following information: Current spot rate of New Zealand dollar = $.41 Forecasted spot rate of New Zealand dollar 1 year from now = $.43 One-year forward rate of the New Zealand dollar = $.42 Annual interest rate on New Zealand dollars = 8% Annual interest rate on U.S. dollars = 9% Given the information in this question, the return from covered interest arbitrage by U.S. investors with $500,000 to invest is ____%. a. about 11.97 b. about 9.63 c. about 11.12 d. about 11.64 e. about 10.63 Hint: $500,000/$.41 = NZ$_______ ? (1.08) = NZ$________ ? _______ = ___________ Yield = 15. Assume that the U.S. one-year interest rate is 3% and the one-year interest rate on Australian dollars is 6%. The U.S. expected annual inflation is 5%, while the Australian inflation is expected to be 7%. You have $100,000 to invest for one year and you believe that PPP holds. The spot exchange rate of an Australian dollar is $0.689. What will be the yield on your investment if you invest in the Australian market? a. 6% b. 3% c. 4% d. 2% Hint: (1 + .05)/(1 + .07) ? $0.689 = $0.676. ($100,000/________) ? (1 + .06) = A$_______ ? $_______ = $________ 5 16. You just received a gift from a friend consisting of 1,000 Thai baht, which you would like to exchange for Australian dollars (A$). You observe that exchange rate quotes for the baht are currently $.023, while quotes for the Australian dollar are $.576. How many Australian dollars should you expect to receive for your baht? a. A$39.93. b. A$25,043.48. c. A$553.00. d. none of the above 17. Assume that the inflation rate in Singapore is 3%, while the inflation rate in the U.S. is 8%. According to PPP, the Singapore dollar should ____ by ____%. a. appreciate; 4.85 b. depreciate; 3,11 c. appreciate; 3.11 d. depreciate; 4.85 18. The one-year forward rate of the British pound is quoted at $1.60, and the spot rate of the British pound is quoted at $1.63. The forward ____ is ____ percent. a. discount; 1.9 b. discount; 1.8 c. premium; 1.9 d. premium; 1.8 19 .If a U.S. firm desires to avoid the risk from exchange rate fluctuations, and it is receiving 100,000 in 90 days, it could: a. obtain a 90-day forward purchase contract on euros. b. obtain a 90-day forward sale contract on euros. c. purchase euros 90 days from now at the spot rate. d. sell euros 90 days from now at the spot rate. 6 20. Assume the Canadian dollar is equal to $.88 and the Peruvian Sol is equal to $.35. The value of the Peruvian Sol in Canadian dollars is: a. about .3621 Canadian dollars. b. about .3977 Canadian dollars. c. about 2.36 Canadian dollars. d. about 2.51 Canadian dollars. 21. A forward contract can be used to lock in the ____ of a specified currency for a future point in time. a. purchase price b. sale price c. A or B d. none of the above 22. A Japanese yen is worth $.0080, and a Fijian dollar (F$) is worth $.5900. What is the value of the yen in Fijian dollars (i.e., how many Fijian dollars do you need to buy a yen)? a. 73.75. b. 125. c. 1.69. d. 0.014. e. none of the above 23. Assume the bid rate of an Australian dollar is $.60 while the ask rate is $.61 at Bank Q. Assume the bid rate of an Australian dollar is $.62 while the ask rate is $.625 at Bank V. Given this information, what would be your gain if you use $1,000,000 and execute locational arbitrage? That is, how much will you end up with over and above the $1,000,000 you started with? 7 a. $10,003. b. $12,063. c. $14,441. d. $16,393. e. $18,219. 24.Assume the following information: Current spot rate of New Zealand dollar = $.41 Forecasted spot rate of New Zealand dollar 1 year from now = $.43 One-year forward rate of the New Zealand dollar = $.42 Annual interest rate on New Zealand dollars = 8% Annual interest rate on U.S. dollars = 9% Given the information in this question, the return from covered interest arbitrage by U.S. investors with $500,000 to invest is ____%. a. about 11.97 b. about 9.63 c. about 11.12 d. about 11.64 e. about 10.63 Hint: $500,000/$.41 = NZ$1,219,512 ? (1.08) = NZ$1,317,073 ? .42 = ________ Yield = ( ________ ? $500,000)/$500,000 = ___________ 25. Cerra Co. expects to receive 5 million euros tomorrow as a result of selling goods to the Netherlands. Cerra estimates the standard deviation of daily percentage changes of the euro to be 1 percent over the last 100 days. Assume that these percentage changes are normally distributed. Use the value-at-risk (VAR) method based on a 95% confidence level for the following question(s). What is the maximum one-day loss if the expected percentage change of the euro tomorrow is 0.5%? a. -0.5% b. -2.2% c. -1.5% d. -1.2% 26.According to interest rate parity (IRP): a. the forward rate differs from the spot rate by a sufficient amount to offset the inflation differential between two currencies. 8 b. the future spot rate differs from the current spot rate by a sufficient amount to offset the interest rate differential between two currencies. c. the future spot rate differs from the current spot rate by a sufficient amount to offset the inflation differential between two currencies. d. the forward rate differs from the spot rate by a sufficient amount to offset the interest rate differential between two currencies. 27. Assume that the interest rate offered on pounds is 5% and the pound is expected to depreciate by 1.5%. For the international Fisher effect (IFE) to hold between the U.K. and the U.S., the U.S. interest rate should be ____. a. 3.43% b. 5.68% c. 6.5% d. 7.3% 28. If a U.S. firm desires to avoid the risk from exchange rate fluctuations, and it will need C$200,000 in 90 days to make payment on imports from Canada, it could: a. obtain a 90-day forward purchase contract on Canadian dollars. b. obtain a 90-day forward sale contract on Canadian dollars. c. purchase Canadian dollars 90 days from now at the spot rate. d. sell Canadian dollars 90 days from now at the spot rate. 29. Assume the following information: Quoted Bid Price Quoted Ask Price Value of an Australian dollar (A$) in $ $0.67 $0.69 Value of Mexican peso in $ $.074 $.077 Value of an Australian dollar in Mexican pesos 8.2 8.5 Assume you have $100,000 to conduct triangular arbitrage. What will be your profit from implementing this strategy? a. $6,133 b. $2,368 9 c. $6,518 d. $13,711 30. Livingston Co. has a subsidiary in Korea. The subsidiary reinvests half of its net cash flows into operations and remits half to the parent. Livingston's expected cash flows from domestic business are $100,000 and the Korean subsidiary is expected to generate 100 million Korean won at the end of the year. The expected value of won is $.0012. What are the expected dollar cash flows of Livingston Co.? a. $100,000 b. $200,000 c. $160,000 d. $60,000 31. If the Fed desires to weaken the dollar without affecting the dollar money supply, it should: a. exchange dollars for foreign currencies, and sell some of its existing Treasury security holdings for dollars. b. exchange foreign currencies for dollars, and sell some of its existing Treasury security holdings for dollars. c. exchange dollars for foreign currencies, and buy existing Treasury securities with dollars. d. exchange foreign currencies for dollars, and buy existing Treasury securities with dollars. 32. A U.S. corporation has purchased currency call options to hedge a 70,000 pound payable. The premium is $.02 and the exercise price of the option is $.50. If the spot rate at the time of maturity is $.65, what is the total amount paid by the corporation if it acts rationally? a. $33,600. b. $46,900. c. $44,100. d. $36,400. Hint: Dollars paid when exercising the option = ?________ ? $.50 = $35,000. Premium paid for options = ?70,000 ? $.02 = Amount of dollars paid = ____________ 33. Jensen Co. expects to pay ?50,000 in one month for its imports from France. It also expects to receive ?200,000 for its exports to Belgium in one month. Jensen estimates the standard 10 deviation of monthly percentage changes of the euro to be 2.5 percent over the last 50 months. Assume that these percentage changes are normally distributed. Using the value-at-risk (VAR) method based on a 97.5% confidence level, what is the maximum one month loss in dollars if the expected percentage change of the euro during next month is 2%? Assume that current spot rate of the euro (before considering the maximum one-month los

Question 5

"1) a) The following is a balance sheet of X corporation just prior to its complete liquidation Cash 15,000 Accts Receiv 10,000 Equipment 5,000 Land 45,000 Total 75,000 Accts payable 18,000 Mortgage payable 30,000 Capital stock 20,000 Earned surplus 7,000 Total 75,000 The fair market value of the land is 100,000 all other property is worth book value. A owns all the X stock, which he acquired for 20,000 several years ago. Disregarding the effect of any corporate level income tax otherwise resulting per Section 336, how much gain will a recognize upon complete liquidation of X a. 62,000 long term capital gain b. 7,000 long term capital gain c. 55,000 long term capital gain d. 75,000 long term capital gain e. none of the above b) Assume that X corporation?s adjusted basis in each of its assets is equal to book value. Assume that fair market value of the land is 100,000 and for all other assets is equal to book value. How much gain is recognized by X corporation pursuant to Section 336 on account of the liquidation a. 55,000 b. None c. 27,000 d. 82,000 c) Assume that X corporation also distributed a patent royalty contract to A which contract does not have an ascertainable fair market value. Disregarding the effect of Section 336, how much gain is recognized by A from the liquidation in the year of liquidation? a. none because the liquidation is open b. 62,000 long term capital gain c. none of the above d) Assume that A reported the liquidation as open and received a 50,000 royalty payment in the third year following the liquidation. How much income is recognized by A with respect to this payment a. 50,000 ordinary income b. 50,000 long term capital gain c. 30,000 ordinary income d. none of the above e) under that fact of question (a) above, what are the tax consequences to A of his payment in a later year of a 10,000 state income tax deficiency imposed on X referable to the year of liquidation? a. 10,000 ordinary loss b. 10,000 long-term capital loss c. A must file an amended return for the year of liquidation reducing the amount of his gain from liquidation d. none of the above