Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please solve the question in 3rd picture by completing the Excel in 4th picture.. Provided 2 reference in 1st and 2nd picture. Please please please
Please solve the question in 3rd picture by completing the Excel in 4th picture.. Provided 2 reference in 1st and 2nd picture.
Please please please solve it, thank you!
subject: Math 1053 Quantitative Methods
It is now a very fast 10 months later and to coincide with the grand opening of Cellar Door, complete with an orange front door of course, Orange Wines would like to prepare a press release for customers promoting the Cellar Door experience. Orange Wines estimates an initial investment of $95,000 is required for vintage (picking the grapes and producing the wine) and equipment to ensure the release of their 2020 Noble Rascal (a Pinot Noir), to be made available at Cellar Door for 12 months. They know it's a huge drawcard to Cellar Door as the staff handpicked, foot stomped, basket pressed and racked the grapes before maturing them in oak, blending and bottling the wine, to present it to you at Cellar Door - so it's definitely worth trying! Icked, foot stompa OT 12 months. Then I their 2020 Noble As it happens this pretty spot in the Adelaide Hills is the only location where this drop is available. Orange Wines charges a $5 premium wine tasting fee per person and expects 950 paying customers per month. In addition, they estimate that on average 50% of customers will purchase a bottle of the cellar door for $32 per bottle. To increase patronage and promote the region, Orange Wines will also invite a popular local chef to offer a dining experience with meals paired with the 2020 Noble Rascal. There are 4 dining sessions running at the end of each quarter for 12 customers at each dining session. The dining package is expected to bring a cash inflow of $180 per customer and each event is expected to be sold out Orange Wines Income Statement financial year ending 30 June 2019) 2019 2018 2017 2016 '000 '000 '000 '000 Sales 989 684 555 420 (less) Expenses (499) (392) (313) (252) Net Profit 490 292 242 168 Orange Wines Balance Sheet (as at 30 June 2019) 2019 2018 '000 '000 Total Assets 446 Total Liability 313 277 Total Equity 209 2017 '000 389 522 272 169 117/ N- 0.04% W $ 178,168.35 000 =B3+NPV(E2,84:815) BCD NPV Month_BC Cash flow_BC Cost of Capital o $ (95,000.00) 1 $ 19,950.00 NPV 19,950.00 28,590.00 4 $ 19,950.00 19,950.00 28,590.00 19,950.00 19,950.00 9 $ 28,590.00 10 $ 19,950.00 11 $ 19,950.00 12 $ 28,590.00 6 $ 9 10 7 $ 11 8 $ 12 13 14 15 16 17 18 4750 15200 19950 48 19 8640 20 28590 21 As a sign the future is looking bright for Orange Wines, they just received the fantastic news their 2019 Noble Rogue vintage has scooped the pool at the recent Wine Industry Awards (Best Vintage 2019, Critic's Choice and Best Oxymoronic Wine Name) with a combined prize money of $50,000. Rather than spend the prize money, Orange Wines have decided to invest it as part of their future funds. The prize money is invested at an interest rate of 2.5% per annum compounded monthly for a 3 year period. Orange Wines have also committed to investing regular deposits of $5,000 in a second investment account that attracts 2.5% per annum compounded quarterly. Orange Wines wants to combine the maturity of the two accounts in 3 years' time. If they have at least $100,000 they will use it to grow the cellar door experience with an upgraded outdoor area and interactive wine tasting tours. Interest Rate BC Duration of investment BC replace this text with your calculation replace this text with your calculation Maturity BC Total Amount of Interest Earned BC replace this text with your calculation replace this text with your calculation Quarterly Deposit Amount BC Interest Rate BC Duration of investment BC replace this text with your calculation replace this text with your calculation 11 12 13 14 Maturity BC Total Amount of Interest Earned BC replace this text with your calculation replace this text with your calculation 15 16 Total replace this text with your calculation 17 18 19 It is now a very fast 10 months later and to coincide with the grand opening of Cellar Door, complete with an orange front door of course, Orange Wines would like to prepare a press release for customers promoting the Cellar Door experience. Orange Wines estimates an initial investment of $95,000 is required for vintage (picking the grapes and producing the wine) and equipment to ensure the release of their 2020 Noble Rascal (a Pinot Noir), to be made available at Cellar Door for 12 months. They know it's a huge drawcard to Cellar Door as the staff handpicked, foot stomped, basket pressed and racked the grapes before maturing them in oak, blending and bottling the wine, to present it to you at Cellar Door - so it's definitely worth trying! Icked, foot stompa OT 12 months. Then I their 2020 Noble As it happens this pretty spot in the Adelaide Hills is the only location where this drop is available. Orange Wines charges a $5 premium wine tasting fee per person and expects 950 paying customers per month. In addition, they estimate that on average 50% of customers will purchase a bottle of the cellar door for $32 per bottle. To increase patronage and promote the region, Orange Wines will also invite a popular local chef to offer a dining experience with meals paired with the 2020 Noble Rascal. There are 4 dining sessions running at the end of each quarter for 12 customers at each dining session. The dining package is expected to bring a cash inflow of $180 per customer and each event is expected to be sold out Orange Wines Income Statement financial year ending 30 June 2019) 2019 2018 2017 2016 '000 '000 '000 '000 Sales 989 684 555 420 (less) Expenses (499) (392) (313) (252) Net Profit 490 292 242 168 Orange Wines Balance Sheet (as at 30 June 2019) 2019 2018 '000 '000 Total Assets 446 Total Liability 313 277 Total Equity 209 2017 '000 389 522 272 169 117/ N- 0.04% W $ 178,168.35 000 =B3+NPV(E2,84:815) BCD NPV Month_BC Cash flow_BC Cost of Capital o $ (95,000.00) 1 $ 19,950.00 NPV 19,950.00 28,590.00 4 $ 19,950.00 19,950.00 28,590.00 19,950.00 19,950.00 9 $ 28,590.00 10 $ 19,950.00 11 $ 19,950.00 12 $ 28,590.00 6 $ 9 10 7 $ 11 8 $ 12 13 14 15 16 17 18 4750 15200 19950 48 19 8640 20 28590 21 As a sign the future is looking bright for Orange Wines, they just received the fantastic news their 2019 Noble Rogue vintage has scooped the pool at the recent Wine Industry Awards (Best Vintage 2019, Critic's Choice and Best Oxymoronic Wine Name) with a combined prize money of $50,000. Rather than spend the prize money, Orange Wines have decided to invest it as part of their future funds. The prize money is invested at an interest rate of 2.5% per annum compounded monthly for a 3 year period. Orange Wines have also committed to investing regular deposits of $5,000 in a second investment account that attracts 2.5% per annum compounded quarterly. Orange Wines wants to combine the maturity of the two accounts in 3 years' time. If they have at least $100,000 they will use it to grow the cellar door experience with an upgraded outdoor area and interactive wine tasting tours. Interest Rate BC Duration of investment BC replace this text with your calculation replace this text with your calculation Maturity BC Total Amount of Interest Earned BC replace this text with your calculation replace this text with your calculation Quarterly Deposit Amount BC Interest Rate BC Duration of investment BC replace this text with your calculation replace this text with your calculation 11 12 13 14 Maturity BC Total Amount of Interest Earned BC replace this text with your calculation replace this text with your calculation 15 16 Total replace this text with your calculation 17 18 19Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started